Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373005 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 / raghavendraprasad
select salary from emp e where &n-1=(select count(*) from
emp where salary>e.salary);
| Is This Answer Correct ? | 7 Yes | 15 No |
Post New Answer View All Answers
How to rename a table?
What is rank function in sql?
what is an alias command? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
How do I audit the sql sent to the server?
Can we change the table name in sql?
What is procedure in pl sql?
What is a schema? How is it useful in sql servers?
How does sql store data?
What are the types of variables use in pl sql?
Which command is used to delete a trigger?
Why do we need a foreign key?
Cite the differences between execution of triggers and stored procedures?
Why use subqueries instead of joins?
What are instead of triggers?
