Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Databases AllOther Interview Questions

What is the difference between primary and candidate key?

0 Answers   BirlaSoft,


What is the relationship that exists inside in E-R diagram?

0 Answers   CGI,


Explain file manager?

0 Answers  


What are different types of resources?

0 Answers  


What is Stored procedure ?

4 Answers   IBM, iGate, Inspira Technologies,


What are the three types of anomalies in database and Explain?

9 Answers  


Explain various types of locks in a transaction? Which is better and why?

0 Answers   Agilent,


What is difference between data and database?

0 Answers  


What is meant by distributed system?

0 Answers  


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.

0 Answers   Amazon,


What are different types of clusters present?

0 Answers   C DAC, CDAC,


aht is the difference b/w network & hierarchial & relational dbms????

0 Answers  


Categories