please give me the answer for this:
query which generates the second highest integer in the table?
Answers were Sorted based on User's Feedback
Answer / river
SELECT * FROM `student` where class='Six' ORDER BY mark desc
LIMIT 1,1
Is This Answer Correct ? | 3 Yes | 1 No |
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 |
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 |
Answer / hamza tariq
select marks from tablename order by marks desc limit 1,1
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sunil kumar
select marks from tablename order by age desc limit 1,1
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
Answer / prasun
SELECT * FROM `student` where class='Six' ORDER BY mark desc
LIMIT 0,1
Is This Answer Correct ? | 1 Yes | 4 No |
How do stored procedures work?
What is heap table?
what is mysql optimization in brief?
How can you count the total number of records of any table?
What are the types of database engines available in mysql?
How do I disable mysql?
how do i list constraints in my database by using sql server2000?
How do I find my mysql username and password?
What is SERIAL data type in MySQL?
What is acid in mysql?
How can I see mysql database?
What are the objects can be created using CREATE statement?