Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367440 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 / arjunraj
aa means table-alias name
bb means table-alisa name
select * from emp aa where 2=(select count(distinct empsalary) from emp bb where aa.empsalary<=bb.empsalary)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is bulk collect in pl sql?
Does oracle roll back the transaction on an error?
How to combine two stored procedures in sql?
Why do we use set serveroutput on?
Explain dml and ddl?
What are joins in sql?
Can primary key be changed?
how to enter characters as hex numbers? : Sql dba
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Why we use joins in sql?
How can we store rows in PL/SQL using array?
What is sql scripting?
What is the use of & in pl sql?
Can we use commit inside a trigger?
Which version of sql do I have?
