SQL Interview Questions

 

Join results of T1 and T2 : T1 1 2 3 NULL  T2 1 4 NULL
 
SQL Query to Find All Employees Who Are Also Managers
 
 
SQL Query to Find All Employees Who Are not
a Managers
 
How to find Nth highest salary from a table
 
Query to return only duplicate records
 
How will you delete duplicate records
 
Show string value coming between 2 dots. like
input : hello.welcome.bye
output : welcome
 
input:
SubjectID       StudentName
----------      -------------
1               Mary
1               John
1               Sam
2               Alaina
2               Edward
output:
SubjectID       StudentName
----------      -------------
1               Mary, John, Sam
2               Alaina, Edward  
x