Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary in SQL(as/4000
- 29 Answers
- 31535 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / sachin
select max(sal) from employees
where salary < (select max(sal) from employees);
| Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
Is oracle sql free?
What are sql data types?
In what condition is it good to disable a trigger?
Does pl/sql support create command?
How does index help in query performance?
Can we use join in subquery?
Which sql most popular?
how can we submit a form without a submit button? : Sql dba
What is normalization? How many normalization forms are there?
What is lookup table in sql?
Can we enter data in a table in design view?
What is sql trigger example?
What are sql functions? Describe in brief different types of sql functions?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
