Interested to Buy Any Domain ? << Click Here >> for more details...
please give me the answer for this:
query which generates the second highest integer in the table?
- 8 Answers
- 8604 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a deterministic function?
What is mysqli_num?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
What is longblob in mysql?
Is foreign key indexed mysql?
How do I restore a database in mysql workbench?
If we use sum function in mysql, does it return sum of that row or for that column?
How to define numeric 9(3) in db2 table without decimal point??
What do we use to remove duplicate records while fetching a data in mysql ?
Explain the difference between mysql and mysql interfaces in php?
What is schema in mysql?
Why do we write stored procedures?
How do I start mysql database?
How do you know if your mysql server is alive?
What are the functions of commit and rollback statements?
