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
- 8945 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 the data source name for mysql?
What is procedures in mysql?
What is mysql protocol?
What is the difference between unix timestamp and mysql timestamp?
What is data types in mysql?
Which statement is used in a select query for partial matching?
List the different types of normalization?
Differentiate CHAR_LENGTH and LENGTH?
Where is the myisam table stored?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
Is mysql from oracle?
Why does mysql have so many connections?
List some mysql advantages and disadvantages?
Which storage engine is best in mysql?
What is mysql routine?
