sql interview quize

# Frequently asked question in interview is ' what is the difference b/w delete,truncate and drop'. DELETE 1. Delete is a DML operation, it can be rollback 2. By using it rows from table can delete. 3. It can used with indexs and views. TRUNCATE 1.  Truncate is a DDL operation, it can not be rollback 2.  By using it all rows from table deleted. 3. It cannot used with indexes and views. DROP 1.  Truncate is a DDL operation, it can not be rollback 2.  By using it whole table delete including the records. 3.  It cannot used with indexes and views.

The question always asked during interview is how to find Nth salary of Employee # Let we consider a table  Employee_Salary  contains the columns  Emp_Id,Emp_Name,Emp_Salary . Employee_Salary   Emp_Name   Emp_Id   Emp_Salary  Rakesh  001  8000  Ashish   002  10000  Shalu   003  11000  Mohit   004  12000  Anurag   005  13000  Bhanu   006  14000 ##  Now we go through N th Salary * SELECT  Top 1 Emp_Salary FROM  (Select  Top Nth   Emp_Salary form  Employee_Salary           order   by  Emp_Salary desc) as EmpSalary order by Emp_Salary   Example #   SELECT   Top 1  Emp_Salary FROM  (Select   Top 3   Emp_Salary form  Employee_Salary  ...