Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361474 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
Can variables be used in sql statements?
how to use 'mysql' to run sql statements? : Sql dba
what are the advantages of sql ? : Sql dba
What is procedure function?
Why schema is used in sql?
Does postgresql run on the cloud?
Which function is used to return remainder in a division operator in sql?
What is the largest value that can be stored in a byte data field?
Why stored procedures are faster than query?
What are all the different normalizations?
What is the advantage of nosql?
How do I edit a stored procedure?
How many clustered indexes can you have?
Is like operator in sql case sensitive?
What does desc stand for?
