Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373106 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 / vikas
select * from(select e.*,row_number() over (order by
e.salary desc)rn from Employee e)where rn between 1 and 2
order by rn
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the sql case statement?
What are pl sql procedures?
What is dynamic query?
What is multiple columns?
What are the types of keys?
What is sql and also describe types of sql statements?
Can we use commit inside a trigger?
What is the basic form of sql query?
What are the types of variable use in pl sql?
What do you understand by pl/sql packages?
when is the use of update_statistics command? : Sql dba
How can you load multi line records? : aql loader
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
How does rowid help in running a query faster?
Why is pl sql used?
