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 can you add and remove any column of a table?
What is information_schema in mysql?
What are the advantages of stored procedures, triggers, indexes?
What is the phantom problem?
What is blob and clob?
How to find second highest salary from a table?
What are the non-standard sql commands supported by 'mysql'?
What is the usage of regular expressions in mysql?
Differentiate CHAR_LENGTH and LENGTH?
How to use like conditions?
How to see the database architecture in MySQL??
How can we store binary data in mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)