Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
584Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
919Two 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.
1372Post New Databases AllOther Questions
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
Which is the best graph database?
Explain file manager?
Explain about ur projets on teradata???
Explain the field term used in database.
What is the difference between a stored procedure and a query?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
Explain artificial key?
What are different types of blocks used in stored procedure?
What are different types of data models available? Explain with example?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
How many indexes can be created on a table?
Explain the various types of normalization.
What is the best database software for small businesses?
Two 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.