Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
468Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
790Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
1169Post New Amazon Databases AllOther Interview Questions
How many types of ambari repositories are available?
What is typedef?
What are cookies in c#?
In abinitio, what types of parallelism are used?
What file will give you oracle instance status information? Where is it located?
What are sql indexes?
What routing means?
How do I change drives in dos?
what is your ideal job?
Name two methods you could use to rename a file?
What are screen painter and menu painter? : abap hr
What is SAS? What are the functions does it performs?
What is core CT & it's function?
Can you insert NULL in unique column?
What is garbage collector?