Write a query to find second highest salary of an employee.
Answer Posted / manikumar
Select Sal from Emp where Sal in (Select Max(Sal) from Emp)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What program will open a mdb file?
What can sql server reporting services do?
what are different types of collation sensitivity? : Sql dba
what are date and time functions in mysql? : Sql dba
Does oracle roll back the transaction on an error?
What is not in sql?
What does where 1/2 mean in sql?
Explian rowid, rownum? What are the psoducolumns we have?
What are sql*plus environment variables?
What is sqlcommand?
What is dense_rank in sql?
How does an execution block start and end in pl sql?
What is package in pl sql with an examples?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
Can we delete column in sql?