Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367867 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / mastan
select name,salary from (select salary from emp order by
salary desc)where rownum<2
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How does sql developer connect to oracle database?
What does 0 mean in sql?
What is a behavioral trigger?
How do you drop a trigger?
What are the parts of a basic sql query?
What is the trigger in sql?
How to get each name only once from an employee table?
Does sql*plus also have a pl/sql engine?
What are the parts of a sql statement?
what are the different type of normalization? : Sql dba
What is rank dense_rank and partition in sql?
Write a unique difference between a function and a stored procedure.
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is materialized view in sql?
What are functions in sql?
