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
What language does mysql use?
Can varchar be primary key?
How can I change database in mysql?
Why should I use mysql?
Can you tell the difference between ereg_replace() and eregi_replace()?
What mysql means?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
How many sql ddl commands are supported by 'mysql'?
How do I change global variables in mysql?
What is the difference between timestamp and datetime in mysql?
How do I change the max connections in mysql?
Is mysql a framework?
State the differences between mongodb and mysql.
what is the default port for mysql server? : Mysql dba
Which is best pdo or mysqli?