how to get second highest salary in SQL(as/4000
Answer Posted / satheeshkumar
Select max(sal) From Employee where sal not in ( Select max
(sal) From Employee)
Is This Answer Correct ? | 24 Yes | 4 No |
Post New Answer View All Answers
What is a unique key and primary key and foreign key?
What are the types of keys?
What are the 3 types of behavioral triggers?
What can I use instead of union in sql?
how to shut down the server with 'mysqladmin'? : Sql dba
How do I view a sql database?
What is difference between hql and native sql?
What are the indexing methods?
what is a constraint? : Sql dba
What is an example of translating a date into julian format?
What are procedures used for?
What is coalesce in sql?
what are date and time data types in mysql? : Sql dba
What are pl/sql packages?
What is error ora-12154: tns:could not resolve the connect identifier specified?