how to find the second highest salary from emp table?
Answer Posted / tarun
SELECT salary FROM tb_salary ORDER BY salary DESC LIMIT 2,1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What are analytic functions in sql?
what are enums used for in mysql? : Sql dba
How many joins in sql?
What are stuff and replace function?
can sql servers linked to other servers like oracle? : Sql dba
How to know the last executed procedure?
What is sql data?
How to raise user-defined exception with custom sqlerrm ?
Explian rowid, rownum?
What is the limitation on the block size of pl/sql?
How do I use google cloud in sql?
Why self join is used in sql?
How many clustered indexes can be created on a table?
What are the different types of tables in sql?