how to find the second highest salary from emp table?
Answer Posted / chandan
select slary from emp order by slary desc limit 1,1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does <> sql mean?
What are % type and % rowtype?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Which one is better subquery or joins?
How is data stored on a disk?
what is a view? : Sql dba
How do I audit the sql sent to the server?
Can we enter data in a table in design view?
Explain the components of sql?
Explain aggregate functions are available there in sql?
What is sqlca in powerbuilder?
How to display the records between two range in Oracle SQL Plus?
Explain the steps needed to create the scheduled job?
Explain the commit statement.
what is offset-fetch filter in tsql? : Transact sql