Most viewed questions in Database

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 • 450 views
0 votes
0 answers

Add Foreign Key to existing table

I want to add a Foreign Key ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
 • 38,010 points • 449 views
0 votes
0 answers

SQL use CASE statement in WHERE IN clause

Can you use a case statement in ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
 • 38,010 points • 447 views
0 votes
0 answers

What is the best design for a database table that can be owned by two different resources, and therefore needs two different foreign keys?

Oct 11, 2019 in Database by Daric
 • 500 points • 447 views
0 votes
0 answers

Simple DateTime sql query

How do I query the DateTime database ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
 • 38,010 points • 446 views
0 votes
1 answer

Things I need to consider before installing MSSQL on Linux

SQL server on Linux is pretty new ...READ MORE

Mar 17, 2019 in Database by Mohor
 • 446 views
0 votes
1 answer

How to do version control for SQL Server database?

Not only can you compare objects at ...READ MORE

Feb 15, 2022 in Database by Neha
 • 9,060 points • 445 views
0 votes
0 answers

SQL Injection Exploiting Login form

I was pondering while at the same ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
 • 38,010 points • 444 views
0 votes
0 answers

Left Join With Where Clause

I need to take all of the ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,010 points • 442 views
0 votes
1 answer

Clustered vs Non-clustered Indexes

Clustered indexes - The indexes according to ...READ MORE

Aug 20, 2018 in Database by DataKing99
 • 8,240 points • 442 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 • 441 views
0 votes
1 answer

Excel vba for loop

You must understand how to use loops ...READ MORE

Apr 5, 2022 in Database by gaurav
 • 23,260 points • 439 views
0 votes
0 answers

How to add Indian Rupee Currency symbol in Google Spreadsheet

I need to add Indian Rupee Currency ...READ MORE

Apr 7, 2022 in Database by Edureka
 • 13,670 points • 436 views
0 votes
1 answer

SQL SELECT from multiple tables

Try this: SELECT p.pid, p.cid, p.pname, c1.name1, c2.name2 FROM ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 63,700 points • 435 views
0 votes
0 answers

Execution sequence of Group By, Having and Where clause in SQL Server?

I'm just not sure how a SQL ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,010 points • 435 views
0 votes
1 answer

How to add a named sheet at the end of all Excel sheets?

Kindly use this one liner: Sheets.Add(After:=Sheets(Sheets.Count)).Name = "new_sheet_name" Or ...READ MORE

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

Excel Date Formatting

Take the following steps: Choose the cells you ...READ MORE

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

Table Scan and Index Scan in SQL

What distinguishes a table scan from an ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,010 points • 426 views
0 votes
1 answer

What does "DISTINCT ON (expression)" do?

The snippet from the Official documentation for PostgreSQL is ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 63,700 points • 425 views
0 votes
1 answer

How to retrieve the current version of a MySQL database management system (DBMS)?

Many responses advise using mysql —version. But ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,700 points • 423 views
0 votes
0 answers

DateTime2 vs DateTime in SQL Server

Which one: datetime datetime2 is the recommended way to store date and ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,010 points • 423 views
0 votes
1 answer

External and Managed Table : HIVE

The metadata information along with the table ...READ MORE

Aug 30, 2018 in Database by kurt_cobain
 • 9,390 points • 422 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 • 420 views
0 votes
0 answers

How can I select the first day of a month in SQL?

I only need to choose the given ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,010 points • 419 views
0 votes
1 answer

Comments in MySQL

Like any other programming language, there are ...READ MORE

Nov 26, 2018 in Database by DataKing99
 • 8,240 points • 419 views
0 votes
1 answer

EXCEL How to check if Column A contains specific value and Column B contains 2 specific values?

If you're looking for the string CHECK in cells ...READ MORE

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

Excel Remove Decimal Places

INT function: Remove digits after decimal in ...READ MORE

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

What's the difference between VARCHAR and CHAR?

Any Unicode data can be stored in ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 63,700 points • 416 views
0 votes
0 answers

What is the difference between varchar and nvarchar?

Is it only that multibyte characters are ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,010 points • 416 views
0 votes
0 answers

Export SQL query data to Excel

My query returns a huge amount of ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 416 views
0 votes
0 answers

Altering column size in SQL Server

How to change the column size of ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
 • 38,010 points • 413 views
0 votes
1 answer

Is MariaDB better than MySQL?

Yes ofcourse MariaDB is better than MySQL. ...READ MORE

Mar 18, 2019 in Database by Keshav
 • 412 views
0 votes
0 answers

Which SQL server should we use for SQL queries to be executed?

I mean to say which SQL server ...READ MORE

Aug 18, 2019 in Database by Sonali
 • 411 views
0 votes
0 answers

What is the syntax to drop a Stored Procedure in SQL Server 2000?

In SQL Server 2000, how do you ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 38,010 points • 409 views
0 votes
2 answers

Case in Select Statement

I think these could be helpful for ...READ MORE

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

How can I confirm a database is Oracle & what version it is using SQL?

Run this SQL: select * from v$version; Output: BANNER ---------------------------------------------------------------- Oracle Database ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 63,700 points • 406 views
0 votes
1 answer

Using SQL "IN" Function in Excel

MATCH is a word that can be ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,670 points • 406 views
0 votes
0 answers

What is the Oracle equivalent of SQL Server's IsNull() function?

In SQL Server we can type IsNull() ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
 • 38,010 points • 403 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 • 403 views
0 votes
1 answer

Failure of moveChunks - MongoDB

No, chunk moves are consistent and deterministic. ...READ MORE

Aug 3, 2018 in Database by kurt_cobain
 • 9,390 points
edited Jun 1, 2023 by Srinath • 397 views
0 votes
1 answer

Auto Increment in SQL

Auto increment keyword allows the user to ...READ MORE

Sep 28, 2018 in Database by DataKing99
 • 8,240 points • 395 views
0 votes
1 answer

NOT IN vs NOT EXISTS

In my opinion, the most efficient way ...READ MORE

Feb 11, 2022 in Database by Neha
 • 9,060 points • 391 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 • 390 views
0 votes
0 answers

How to fix Recovery Pending State in SQL Server Database?

How to fix Recovery Pending State in ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
 • 38,010 points • 389 views
0 votes
0 answers

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
 • 38,010 points • 389 views
0 votes
1 answer

Data Models operations HBase

Put Method – To store data in ...READ MORE

Aug 9, 2018 in Database by kurt_cobain
 • 9,390 points • 389 views
0 votes
0 answers

What's the difference between Google Cloud Spanner and Cloud SQL?

I am new to the GCP stack ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 386 views
0 votes
1 answer

Fragmentation in Database

Fragmentation is a feature which controls the ...READ MORE

Sep 4, 2018 in Database by Sahiti
 • 6,370 points • 386 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.