Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361206 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 / mastan
select name,salary from (select salary from emp order by
salary desc)where rownum<2
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the key differences between SQL and PL SQL?
How to look at the current sql*plus system settings?
Which sorts rows in sql?
Can you join views in sql?
What are the advantages of indexing?
how to rename an existing table in mysql? : Sql dba
Which is better trigger or stored procedure?
What is an implicit commit?
Can you have a foreign key without a primary key?
What is the function that is used to transfer a pl/sql table log to a database table?
What do you mean by field in sql?
What is cte?
Explain the difference between 'between' & 'and' operators in sql
What is a schema sql?
what are the advantages a stored procedure? : Sql dba
