Interested to Buy Any Domain ? << Click Here >> for more details...
find highest salary
- 8 Answers
- 8076 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subashvns
SELECT DISTINCT (
s1.salary
)
FROM `salary` s1
WHERE n -1 = (
SELECT count( DISTINCT (
s2.salary
) )
FROM `salary` s2
WHERE s2.salary > s1.salary )
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / renji
SELECT DISTINCT (
s1.salary
)
FROM `salary` s1
WHERE n -1 = (
SELECT count( DISTINCT (
s2.salary
) )
FROM `salary` s2
WHERE s2.salary > s1.salary )
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / qadeer
SELECT DISTINCT (
s1.salary
)
FROM `salary` s1
WHERE n -1 = (
SELECT count( DISTINCT (
s2.salary
) )
FROM `salary` s2
WHERE s2.salary > s1.salary )
| Is This Answer Correct ? | 2 Yes | 2 No |
FOR Nth Highest Salary Where N= 1,2,3,4
SELECT * FROM EMP E1 WHERE N=(SELECT COUNT(DISTINCT SAL)
FROM EMP E2 WHERE E1.SAL <= E2.SAL)
I have tested This Query on MySQL 5.1.41. its working fine.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / richa
$P = shell_exec("SELECT salary
FROM mytable
ORDER BY
salary DESC");
echo $p[0];
| Is This Answer Correct ? | 0 Yes | 2 No |
How many types of array supported in php?
What is the difference between abstract class and interface in php?
How to set cookies in PHP?
how to do connectivity of 2 dbs in PHP script?
What are the encryption functions in php?
What is php routing?
explain in brief type juggling in php?
how to retrieve from database..... this format (PRMRMDU402). firstname= prabhu, lastname=kumar, city=madurai, pincode=624402.... i want first name first two letters and last name last two letters ... city first two letters ... pin code last three letters....
What is the method to register a variable into a session?
Which have the fastest execution between mysql_fetch_array() and mysql_fetch_assoc()
Which function is used in php to delete a file?
When you want to show some part of a text displayed on an html page in red font color? What different possibilities are there to do this? What are the advantages/disadvantages of these methods?
PHP 
