Given a table Employee which has columns name and salary, write an SQL query to

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

Question Posted / anurag kumar tripathi

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

More Databases AllOther Interview Questions

Write a query to get maximum and second maximum in oracle?

What happens when shared and exclusive locks are applied on data item?

give a simple example of physical and logical data independence

What are different types of joins used in?

Explain the record term used in database.

What is ole db ado?

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

Explain entity type?

What is ole db source in ssis?

Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?

what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

What is the difference between database and server?

For more Databases AllOther Interview Questions Click Here