please give me the answer for this: query which generates the second highest in

Categories >> Software >> Databases >> MySQL
Suggest New Category

please give me the answer for this:
query which generates the second highest integer in the table?

Question Posted / shiva034

8 Answers
8998 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

please give me the answer for this: query which generates the second highest integer in the table?..

Answer / river

SELECT * FROM `student` where class='Six' ORDER BY mark desc
LIMIT 1,1

Is This Answer Correct ?

3 Yes

1 No

please give me the answer for this: query which generates the second highest integer in the table?..

Answer / salil

Without using LIMIT

SELECT max( t1.col )
FROM `table` t1
WHERE t1.col < (SELECT max( t2.col ) FROM `table` t2);

Is This Answer Correct ?

2 Yes

1 No

please give me the answer for this: query which generates the second highest integer in the table?..

Answer / sunil kumar

Sorry I have a mistake in above answer. The right answer is

select marks from tablename order by marks desc limit 1,1

Is This Answer Correct ?

1 Yes

0 No

please give me the answer for this: query which generates the second highest integer in the table?..

Answer / hamza tariq

select marks from tablename order by marks desc limit 1,1

Is This Answer Correct ?

1 Yes

0 No

please give me the answer for this: query which generates the second highest integer in the table?..

Answer / sunil kumar

select marks from tablename order by age desc limit 1,1

Is This Answer Correct ?

0 Yes

0 No

please give me the answer for this: query which generates the second highest integer in the table?..

Answer / vardhan rao

With Limit: nth highest salary

Select distinct(salary) from tablename order by salary desc
limit n-1,1

Is This Answer Correct ?

0 Yes

1 No

please give me the answer for this: query which generates the second highest integer in the table?..

Answer / richa

This is a general solution to nth level of salary

Select salary from (select salary from table order by salary
desc limit 3) tbl order by salary limit 1

Is This Answer Correct ?

0 Yes

2 No

please give me the answer for this: query which generates the second highest integer in the table?..

Answer / prasun

SELECT * FROM `student` where class='Six' ORDER BY mark desc
LIMIT 0,1

Is This Answer Correct ?

1 Yes

4 No

Post New Answer

More MySQL Interview Questions

What is row level locking in mysql?

0 Answers

Where is mysql password stored?

0 Answers

Which is best pdo or mysqli?

0 Answers

How do I clear the screen in mysql?

0 Answers

What is difference between mysqli and pdo?

0 Answers

How to delete a table.

0 Answers

How do I backup mysql database on linux?

0 Answers

Is there a way to see the files which are stored?

0 Answers

Explain the storage engines in mysql?

0 Answers

How much does mysql cost?

0 Answers

Why do we use pragma autonomous transaction?

0 Answers

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers

For more MySQL Interview Questions Click Here