Trending questions in Database

0 votes
1 answer

Which SQL query is used to find Nth highest salary from a salary table

If you want to find nth Salary ...READ MORE

Feb 14, 2022 in Database by Vaani
 • 7,020 points • 2,341 views
0 votes
1 answer

Excel problem for beginners: #REF! Error When referenced Row is deleted or Added

You'll run into this problem if you ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 294 views
0 votes
1 answer

Calculating percentile - Excel vs online

Syntax PERCENTILE(array,k) The following are the arguments to the ...READ MORE

Mar 31, 2022 in Database by gaurav
 • 23,260 points • 407 views
0 votes
0 answers

How to split a string of text in excel based on a given word?

I have a list of combinations of ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 250 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,156 views
0 votes
0 answers

in MS excel find first non n/a value in row

I have dates (Jan-2014 in cell A1, ...READ MORE

Mar 30, 2022 in Database by Edureka
 • 13,670 points • 443 views
0 votes
1 answer

Excel: Highlighting duplicates with exact matches

To enter the Advanced Filter dialogue box, ...READ MORE

Mar 24, 2022 in Database by gaurav
 • 23,260 points • 662 views
0 votes
0 answers

Check Excel file format from PowerScript not relying on file extension

We have a number of Excel files ...READ MORE

Mar 31, 2022 in Database by Edureka
 • 13,670 points • 335 views
0 votes
1 answer

how do I calculate discount with if function in excel

Notes about the release; Frameworks to aim ...READ MORE

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

How to read and write excel file

When broken down into steps, reading an ...READ MORE

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

Number of elements in a single dimension variant array in excel

You must do UBound - LBound + ...READ MORE

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

How to read and write excel file

When broken down into steps, reading an ...READ MORE

Mar 25, 2022 in Database by Edureka
 • 13,670 points • 483 views
0 votes
1 answer

Conditional Sum in Excel that counts values above X as X

B1 formula is: =SUMIF(A1:A5,"<=5") +COUNTIF(A1:A5,">5") *5 Fill in the blanks ...READ MORE

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

How to read a .xlsx file using the pandas Library in iPython?

Every sheet gets its own DataFrame, which ...READ MORE

Mar 25, 2022 in Database by anonymous
 • 481 views
0 votes
1 answer

Retrieving Cell name in Excel

ADDRESS(ROW(),COLUMN()) returns the current cell's address, such ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 268 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,670 points • 1,728 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 • 1,642 views
0 votes
1 answer

SQL Server: PARTITION BY vs GROUP BY

To understand the differences between GROUP BY ...READ MORE

Feb 9, 2022 in Database by Neha
 • 9,060 points • 2,214 views
0 votes
0 answers

Count colored cell on excel automatically

I'm trying to count the number of ...READ MORE

Mar 28, 2022 in Database by Edureka
 • 13,670 points • 223 views
0 votes
1 answer

Are there such things as variables within an Excel formula?

Yes. However, not directly. a less complicated method You ...READ MORE

Mar 25, 2022 in Database by gaurav
 • 23,260 points • 311 views
0 votes
0 answers

Excel PERCENTRANK.INC in Javascript

Is there a way to get the ...READ MORE

Mar 23, 2022 in Database by Edureka
 • 13,670 points • 307 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,670 points • 1,461 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,398 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 • 581 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,020 points • 1,301 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,386 views
0 votes
1 answer

What is the definition of cardinality in SQL?

Cardinality is defined as the "number of ...READ MORE

Feb 15, 2022 in Database by Neha
 • 9,060 points • 1,566 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 • 434 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,227 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 • 389 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 • 370 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,080 views
0 votes
1 answer

How can I define a composite primary key in SQL?

A primary key is unique and it ...READ MORE

Feb 21, 2022 in Database by Vaani
 • 7,020 points • 1,155 views
0 votes
1 answer

How do I perform an IF THEN statement in an SQL SELECT?

The CASE statement is the closest to IF in ...READ MORE

Feb 16, 2022 in Database by Vaani
 • 7,020 points • 1,254 views
0 votes
1 answer

LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

At the top level there are mainly ...READ MORE

Feb 4, 2022 in Database by Neha
 • 9,060 points • 1,660 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 • 868 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 • 840 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 • 841 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,020 points • 674 views
0 votes
1 answer

Convert Rows to columns using 'Pivot' in SQL Server

You can use the PIVOT function to ...READ MORE

Feb 8, 2022 in Database by Vaani
 • 7,020 points • 1,316 views
0 votes
1 answer

Number of rows affected by an UPDATE in PL/SQL

You can try using the following query: SELECT ...READ MORE

Feb 14, 2022 in Database by Vaani
 • 7,020 points • 999 views
0 votes
1 answer

Please name some online websites to compile and run PL/SQL?

For executing Oracle SQL queries and PL/SQL ...READ MORE

Feb 11, 2022 in Database by Neha
 • 9,060 points • 1,120 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,020 points • 526 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 • 594 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,670 points • 520 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,020 points • 446 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 • 504 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 • 557 views
0 votes
1 answer

How Can I use "Date" Datatype in sql server?

There's problem in all of them and ...READ MORE

Feb 9, 2022 in Database by Neha
 • 9,060 points • 1,049 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,020 points • 503 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.