Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368419 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 / dinesh rajput
select sal from(select sal from
(select distinct sal from emp order by sal desc)
where rownum<=2 order by sal asc)
where rownum=1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is natural join in sql?
Why are cursors used?
What is the maximum number of rows in sql table?
What is cursor and its types?
What is the sql query to display the current date?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is right join in sql?
how to shutdown mysql server? : Sql dba
Write a sql query to find the names of employees that begin with ‘a’?
What is the most common sql injection tool?
Can we create table inside stored procedure?
What are the subsets of sql?
What is sql and also describe types of sql statements?
how to convert character strings to numeric values? : Sql dba
What language is oracle sql developer?
