Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368194 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 / hemanth kumar
select salary from employees where rowid=(select rowid from
employees where rownum<=2
minus
select rowid from employees where rownum<2)
order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is an alias command? : Sql dba
What does varchar include?
what are the join types in tsql? : Transact sql
define sql delete statement ? : Sql dba
Can a table contain multiple primary key’s?
Define sql delete statement.
What is the usage of the distinct keyword?
how do you know if your mysql server is alive? : Sql dba
How many sql commands are there?
Which join condition can be specified using on clause?
how to create a test table in your mysql server? : Sql dba
What is varchar data type in sql?
is it possible to pass an object or table to a procedure as an argument?
What is full join in sql?
Which is better trigger or stored procedure?
