Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368581 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 the difference between an inner and outer join?
Which version of sql do I have?
What does stand for in sql?
Why does sql need a server?
What is not in sql?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
discuss about myisam index statistics collection. : Sql dba
How many types of cursors supported in pl/sql?
Explain alias in sql?
Can we use two order by clause in query?
Is not null in sql?
Can you have more than one trigger on a table?
What is group function in sql?
Enlist the data types that can be used in pl/sql?
What is crud sql?
