Most voted questions in Database

0 votes
1 answer

Excel formula to remove comma, spaces, period and add a text

The steps to accomplish this are as ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 2,225 views
0 votes
1 answer

Excel 2003 - Match Column A with Column B & Column C to correspond to Column B

Write a standard IF formula that compares ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 2,879 views
0 votes
1 answer

Remove duplicates within a row

To check for duplicates, choose the cells ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 604 views
0 votes
1 answer

Prevent cell numbers from incrementing in a formula in Excel

In Excel, you can use a feature ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 9,942 views
0 votes
1 answer

Sigma or Summation function in Excel

The SUM function in Excel is another ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 13,463 views
0 votes
1 answer

How to Export Tally Data programmatically to CSV or Excel format

Open data (Ledger/P&L or Balance Sheet) that ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 2,922 views
0 votes
1 answer

How to count distinct values in Excel

Use functions to count the number of ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 1,352 views
0 votes
1 answer

Excel VBA - exit for loop

When we need to depart the For ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 794 views
0 votes
1 answer

Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 1,552 views
0 votes
0 answers

Merging Two excel files as two sheets in one workbook in java

I have two xlsx files at folder ...READ MORE

Mar 10, 2022 in Database by Edureka
 • 13,690 points • 1,581 views
0 votes
1 answer

Reading Excel File using Python, how do I get the values of a specific column with indicated column name?

We can read excel more easily with ...READ MORE

Mar 14, 2022 in Database by gaurav
 • 23,260 points • 4,422 views
0 votes
1 answer

Importing notepad data to excel (difficult split)

Excel: How to Use It On the Data ...READ MORE

Mar 14, 2022 in Database by gaurav
 • 23,260 points • 563 views
0 votes
1 answer

MS Excel - SumProduct formula with Loop

Drag this to the right of cell ...READ MORE

Mar 14, 2022 in Database by gaurav
 • 23,260 points • 583 views
0 votes
0 answers

How to change column datatype in SQL database without losing data?

I have a SQL Server database, and ...READ MORE

Feb 25, 2022 in Database by Vaani
 • 7,070 points • 671 views
0 votes
0 answers

What's the difference between a temp table and table variable in SQL Server?

We can build temp tables in SQL ...READ MORE

Feb 25, 2022 in Database by Vaani
 • 7,070 points • 597 views
0 votes
0 answers

Order Of Execution of the SQL query

I'm not sure what sequence this query ...READ MORE

Feb 25, 2022 in Database by Vaani
 • 7,070 points • 823 views
0 votes
0 answers

SELECT.... WHERE... OR

Is there a method to choose data ...READ MORE

Feb 25, 2022 in Database by Vaani
 • 7,070 points • 347 views
0 votes
0 answers

Select .... where .... OR?

Is there a method to choose data ...READ MORE

Feb 24, 2022 in Database by Hemant
 • 140 points • 343 views
0 votes
0 answers

Testing question and answer

This category discusses everything related to SQL/ ...READ MORE

Feb 24, 2022 in Database by anonymous
 • 140 points • 323 views
0 votes
0 answers

Duckworth-Lewis-Stern calculator to calculate the revised target

With the Cricket World Cup going on, ...READ MORE

Feb 24, 2022 in Database by Edureka
 • 13,690 points • 469 views
0 votes
0 answers

If Cell Starts with Text String... Formula

I have formula that checks if the ...READ MORE

Feb 24, 2022 in Database by Edureka
 • 13,690 points • 1,558 views
0 votes
0 answers

How to import JSON file to Excel without coding?

Let's say you have a file named input.json which ...READ MORE

Feb 24, 2022 in Database by Edureka
 • 13,690 points • 703 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24, 2022 in Database by Edureka
 • 13,690 points • 1,990 views
0 votes
1 answer

Rename column SQL Server 2008

Use sp_rename EXEC sp_RENAME 'TableName.PreviousColumnName' , 'NewColumnName', 'COLUMN' See: SQL SERVER ...READ MORE

Feb 23, 2022 in Database by Vaani
 • 7,070 points • 631 views
0 votes
0 answers

How Stuff and 'For Xml Path' work in SQL Server?

Table is: Id Firstname 4 abc 4 def 4 ghi 4 jkl 4 mno Required output: Id Name 4 abc,def,ghi,jkl,mno Query: SELECT ID, ...READ MORE

Feb 23, 2022 in Database by Neha
 • 9,060 points • 5,898 views
0 votes
1 answer

How to calculate age (in years) based on Date of Birth and getDate()

Following can be a solution to your ...READ MORE

Feb 23, 2022 in Database by Vaani
 • 7,070 points • 1,515 views
0 votes
1 answer

Convert Date format into DD/MMM/YYYY format in SQL Server

Using convert() and style 106, you can ...READ MORE

Feb 23, 2022 in Database by Vaani
 • 7,070 points • 13,918 views
0 votes
1 answer

Converting HTML to Excel? [closed]

Upload html-file(s) Select files from Computer, Google ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 547 views
0 votes
1 answer

how do I calculate discount with if function in excel?

Suppose a customer gets a 10 percent ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 11,071 views
0 votes
1 answer

Deleting duplicate rows in Excel using Epplus

You need to re-think this… the while ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 1,391 views
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 5,154 views
0 votes
0 answers

SQL: Display Full Name + Filter By Subject

Feb 22, 2022 in Database by Neha
 • 9,060 points • 271 views
0 votes
1 answer

Insert into ... values ( SELECT ... FROM ... )

Try: INSERT INTO tableA ( column_1 ) SELECT ...READ MORE

Feb 23, 2022 in Database by Neha
 • 9,060 points • 1,566 views
0 votes
1 answer

How to convert DateTime to VarChar

With Microsoft Sql Server: -- -- Create test case -- DECLARE ...READ MORE

Feb 23, 2022 in Database by Neha
 • 9,060 points • 1,131 views
0 votes
1 answer

What is the Oracle PL/SQL "--+rule"?

The answer is in the material you ...READ MORE

Feb 23, 2022 in Database by Neha
 • 9,060 points • 2,018 views
0 votes
1 answer

What is the candidate key in SQL Server?

A Candidate Key is any column or ...READ MORE

Feb 23, 2022 in Database by Neha
 • 9,060 points • 4,202 views
0 votes
0 answers

What is "with (nolock)" in SQL Server?

Can someone explain the ramifications of using ...READ MORE

Feb 22, 2022 in Database by Vaani
 • 7,070 points • 595 views
0 votes
1 answer

Date difference: different results in Excel vs. Python

To calculate the date difference, we can ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 1,093 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 780 views
0 votes
1 answer

Excel - Split cell with a delimiter and if delimiter not found get complete cell value to another cell

Select the row or column that you ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 670 views
0 votes
1 answer

Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 1,748 views
0 votes
1 answer

SQL SELECT WHERE field contains words

Use this query to include any of words: SELECT * ...READ MORE

Feb 21, 2022 in Database by Neha
 • 9,060 points • 19,745 views
0 votes
1 answer

SQL count rows in a table

A fast way of doing this would ...READ MORE

Feb 21, 2022 in Database by Neha
 • 9,060 points • 713 views
0 votes
1 answer

SQL query to find third highest salary in company

The easiest way to work this out ...READ MORE

Feb 21, 2022 in Database by Neha
 • 9,060 points • 50,732 views
0 votes
1 answer

What is "with (nolock)" in SQL Server?

Using READ UNCOMMITED as a transaction isolation ...READ MORE

Feb 21, 2022 in Database by Neha
 • 9,060 points • 625 views
0 votes
1 answer

Reading Excel File using Python, how do I get the values of a specific column with indicated column name?

So the key parts are to grab ...READ MORE

Feb 21, 2022 in Database by gaurav
 • 23,260 points • 4,639 views
0 votes
1 answer

Change default 'delimiters' in excel

Select a non-empty cell. Do Data -> Text ...READ MORE

Feb 21, 2022 in Database by gaurav
 • 23,260 points • 1,787 views
0 votes
1 answer

Merging Two excel files as two sheets in one workbook in java

Basically for this, you need to create ...READ MORE

Feb 21, 2022 in Database by gaurav
 • 23,260 points • 1,033 views
0 votes
1 answer

Group by Sum in Excel

It is very easy and you can ...READ MORE

Feb 21, 2022 in Database by gaurav
 • 23,260 points • 549 views
0 votes
1 answer

How do I use ROW_NUMBER()?

You can use the query as: SELECT COUNT(*) ...READ MORE

Feb 21, 2022 in Database by Vaani
 • 7,070 points • 512 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.