how to get second highest salary in SQL(as/4000
Answer Posted / deepak
select max(sal) from emp where sal!=(select max(sal) from emp);
Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
What is the purpose of primary key?
What is the least restrictive isolation level? : Transact sql
What is the mutating table and constraining table?
What is difference between sql and mysql?
Explain the difference between triggers and constraints?
what is a record in a database ? : Sql dba
What is materialized view. What are different methods of refresh?
What does pl sql stand for?
Is it possible to link two groups inside a cross products after the cross products group has been created?
How do you explain an index number?
Cite the differences between execution of triggers and stored procedures?
How to avoid duplicate records in a query?
How is use pl and sql?
how many values can the set function of mysql take? : Sql dba
What are the commands used in sql?