ALLInterview.com
Categories
|
Companies
|
Placement Papers
|
Code Snippets
|
Certifications
|
Visa Questions
Post Questions
|
Post Answers
|
My Panel
|
Search
|
Topics
|
Errors
husenaiah
{ City } bangalore
< Country > india
* Profession * se
User No #
5193
Total Questions Posted #
0
Total Answers Posted #
1
Total Answers Posted for My Questions # 0
Total Views for My Questions # 0
Users Marked my Answers as Correct # 22
Users Marked my Answers as Wrong # 38
Questions / { husenaiah }
Questions
Answers
Category
Views
Company
eMail
Answers / { husenaiah }
Question
{
Hewitt
,
128782 }
find out the third highest salary?
Answer
select empno,ename,sal from
(select empno,ename,sal from emp order by sal desc)
group by rownum,ename,sal having rownum=&n;
from this query we can find top nth sal
Is This Answer Correct ?
22 Yes
38 No