Want to know the 10th max salary in salary table

Answers were Sorted based on User's Feedback



Want to know the 10th max salary in salary table..

Answer / amar banerjee

SELECT sal FROM salary SORT BY sal desc limit 9,1

Is This Answer Correct ?    16 Yes 5 No

Want to know the 10th max salary in salary table..

Answer / anz

SELECT sal FROM salary ORDER BY sal DESC 9,1

Is This Answer Correct ?    8 Yes 6 No

Want to know the 10th max salary in salary table..

Answer / jose_100

SELECT SAL FROM SALARY_TABLE ORDER BY SAL DESC LIMIT 9, 10;

Is This Answer Correct ?    5 Yes 3 No

Post New Answer

More PHP Interview Questions

What is a controller php?

0 Answers  


What is the difference between file_get_contents() and file_put_contents() in php?

0 Answers  


How can I reset an array in PHP?

4 Answers   Rushmore Consultancy, TCS,


What is cookie in php with example?

0 Answers  


How will you create a bi-lingual site (multiple languages) ?

3 Answers  






Why do we use query?

0 Answers  


How big is nvarchar max?

0 Answers  


What is the use of "echo" in php?

0 Answers  


how to upload more than 50 mb? i tried but session was expired....certain time .....i was set session duration three days .... how to rectified? if any one know that post ur answer as soon as possible? thanks

1 Answers  


What is $row in php?

0 Answers  


What does $_server means?

0 Answers  


What are the difference between include_once & Require_once?

2 Answers  


Categories