Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary in SQL(as/4000
- 29 Answers
- 32111 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / raji_4u
select *
from emp e1
where 2 = ( select count(distinct sal)
from emp e2
where e1.sal <= e2.sal
)
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is transaction control language (tcl)?
Write the alter statement to enable all the triggers on the t.students table.
Why we use cross join?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What is the life of an sql statement?
How do I view output in sql developer?
What does desc stand for?
How many types of relationship are there?
What are the types of index in sql?
How to use distinct and count in sql query? Explain
Can we use rowid as primary key?
Is postgresql a nosql database?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How to place comments in pl/sql?
What is serial sql?
