Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
1133Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
1473Two 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.
1895Post New Databases AllOther Questions
Explain database partitioning. What is its importance?
What is a database call?
What are the various ways to execute a query in teradata?
Should I store images in database?
List various types of log-based recovery in DBMS.
Difference between sql and mysql?
What is database server and how it works?
What happens when shared and exclusive locks are applied on data item?
List some advantages of dbms.
How default key is different from primary key?
what is rcp,if rcp disabled what happen?
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
What is the concept of Virtual field?
What is the function of cluster index?
What is the difference between oracle and MS Access?