please give me the answer for this:
query which generates the second highest integer in the table?
Answer Posted / 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 |
Post New Answer View All Answers
How to make a column bigger and delete unique from table.
How do I quit mysql?
What do ddl, dml, and dcl stand for?
What is a scalar function?
What is heap table?
What is mysql connection limit?
Can you tell what are various ways to create an index?
How to execute mysql query in php?
Is pdo faster than mysqli?
Is mysql an oracle product?
how you will Create a database on the mysql server with unix shell.
How to define numeric 9(3) in db2 table without decimal point??
What is the difference between now() and current_date()?
How to upload a large file through phpmyadmin in mysql?
How many rows can a mysql table hold?