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
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is the difference between sql and isql*plus?
What is the difference between numeric and autonumber?
How do I view a sql database?
How to write pl sql program in mysql command prompt?
What do you know by pl/sql cursors?
What is scope of pl sql developer in future?
Explain how to use transactions efficiently : transact sql
How do you change a value in sql?
Is left join faster than inner join?
What is scope and visibility in PL/SQL?
What does inner join mean?
How to create an array in pl/sql?
What is procedure explain with program?
What are string functions in sql?