SQL INTERVIEW QUESTONS

The function of count(*), count(1), count(‘a’) is same. That means that they all gives count of all the rows including...

Drop Table: This statement deletes the table from the database. Truncate:  This statement deletes all the rows from the table...

The function of count(*), count(1), count(‘a’) is same. That means that they all gives count of all the rows including...

Data id name salary department 1 Gaurav 50200 Account 2 Pyush 10960 HR 3 Ram 70870 Secutity 4 Lakshaman 8600...

Data YEAR GOLD SILVER BRONZE 2000 Alex Dhruv Shyam 2001 Dev Duggu Chandan 2002 Saksham Arora Dev Lovekush 2003 Ayush...