how to get second highest salary in SQL(as/4000
- 29 Answers
- 25627 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / praveen agrawal
select sal from employee order by sal desc limit 1,1;
its 100% true i have checked it out.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is recursive join in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How do I view tables in mysql?
What type of database is sql?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
Do we need to create index on primary key?
Is crud a cuss word?
Why query optimization is needed?
What is a behavioral trigger?
Who developed sql?
How is sql used in oracle?
What is execute immediate?
What is sql prepared statement?
What is oracle sql called?
