how to find the second highest salary from emp table?
Answer Posted / gunjal ghagre
Select sal from table_name order by sal desc limit 1,1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to place comments in pl/sql?
Sql technical questions
what is foreign key? : Sql dba
What is the syntax to add a record to a table?
Show the two pl/sql cursor exceptions.
How does cross join work in sql?
Why is there a need for sqlcode and sqlerrm variables?
How do you define a foreign key?
what is the difference between join and union? : Sql dba
what is the difference between $message and $$message? : Sql dba
what are string data types? : Sql dba
What are types of exception?
give the syntax of grant and revoke commands? : Sql dba
what is the difference between truncate and drop statements? : Sql dba
What is sql query limit?