Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361088 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 / jitendra kumar
select salary from (select salary from emp ordery by salary
(dese) where rownum>=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a delimiter in sas?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is difference sql and mysql?
what is the command line end user interface - mysql? : Sql dba
What is composite primary key in sql?
Can there be 2 primary keys in a table?
How to set up sql*plus output format in oracle?
What is the command used to fetch first 5 characters of the string?
What is sql scripting?
how to create a new view in mysql? : Sql dba
Can you upgrade sql express to full sql?
Differentiate between % rowtype and type record.
How do I find duplicates in two columns?
Explain ddl statements in pl/sql?
Can %notfound return null after a fetch?
