Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361212 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 / amy
select TOP salary from employee where salary in( select TOP 2 salary from employee order by salary desc) order by salary asc
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which command is used to delete a package?
Can we create index on primary key?
What are the types of subqueries?
Can a select statement fire a trigger?
What is the difference between union and union all command?
What are literals in sql server?
What is sequence in sql?
When should I use nosql database?
Mention what plvcmt and plvrb does in pl/sql?
What is sql engine in oracle?
Is merge a dml statement?
Can we perform dml on view?
What is compute?
what is a trigger? : Sql dba
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
