how to find the second highest salary from emp table?
- 211 Answers
- 321381 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / dinesh
select * from emp order by sal desc limit 1,1
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Which table is left in left join?
What is the purpose of the primary key?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Is ms sql is free?
explain the difference between delete , truncate and drop commands? : Sql dba
How to run sql commands in sql*plus?
what is 'mysqldump'? : Sql dba
What is coalesce sql?
What is a boolean in sql?
How do we use distinct statement? What is its use?
Is postgresql a server?
what are the 'mysql' command line options? : Sql dba
What is recursive stored procedure?
what happens if you no create privilege in a database? : Sql dba
Can we use joins in subquery?
