how to find the second highest salary from emp table?
Answer Posted / kishor dange
select max(sal) from table_name where sal<(select max(sal)
from table_name)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is primary key always clustered index?
What is implicit cursor in pl sql?
Can %notfound return null after a fetch?
how can we find the number of rows in a table using mysql? : Sql dba
What is a loop in sql?
Differentiate pl/sql and sql?
What is localdb mssqllocaldb?
What program will open a mdb file?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How can you fetch first 5 characters of the string?
What sql database should I use?
What company owns postgresql?
Can I join the same table twice?
how to get a list of indexes of an existing table? : Sql dba
Explain exception handling in pl/sql?