Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 28793 Views
- I also Faced
- E-Mail Answers
Answer Posted / akilis.org@hotmail.com
Let us assume that
Table Name:salary
Coloumn Name:maxsal(int)
select * from salary order by maxsal desc limit 1,1;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we use joins in subquery?
Explain character-manipulation functions?
What is trigger with example?
How is data stored in sql?
what are all the different normalizations? : Sql dba
what is error ora-03113: end-of-file on communication channel?
Is sql pronounced sequel or sql?
Why is sql important?
What is Materialized View? In What Scenario we Use Materialized View?
Why do we create views in sql?
What are the different types of dbmss?
What is a clob in sql?
What is the purpose of the primary key?
What does over partition by mean in sql?
What is union and union all keyword in sql?
