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 do you modify a column in sql?
What is the difference between left and left outer join?
What are the types of subqueries?
Does user triggers have entry for trigger with compilation errors?
Can we rollback delete command?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What is db journal file?
How do I enable sql encryption?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What are different types of tables in sql?
What is sql injection vulnerability?
What is sql deadlock?
What is rownum?
What is difference between table and view?
what is bcp? When does it used? : Sql dba