ALLInterview.com
Categories
|
Companies
|
Placement Papers
|
Code Snippets
|
Certifications
|
Visa Questions
Post Questions
|
Post Answers
|
My Panel
|
Search
|
Topics
|
Errors
thananjayan
{ City } chennai
< Country > india
* Profession * student
User No #
64319
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 # 1
Users Marked my Answers as Wrong # 0
Questions / { thananjayan }
Questions
Answers
Category
Views
Company
eMail
Answers / { thananjayan }
Question
{
TCS
,
76168 }
find out the second highest salary?
Answer
SELECT * FROM 'emp` WHERE salary < ( SELECT max( salary
)FROM emp ) ORDER BY salary DESC LIMIT 1
This is Mysql syntax, if you use Oracle just remove LIMIT 1
and put it ROWNUM=1;
Is This Answer Correct ?
1 Yes
0 No