find highest salary

Answers were Sorted based on User's Feedback



find highest salary..

Answer / sunil kumar

select max(salary) from tablename

Is This Answer Correct ?    30 Yes 0 No

find highest salary..

Answer / ritu

select max(salary) from tablename

Is This Answer Correct ?    5 Yes 0 No

find highest salary..

Answer / subhra

select max(salary) from table_name;

Is This Answer Correct ?    2 Yes 0 No

find highest salary..

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

find highest salary..

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

find highest salary..

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

find highest salary..

Answer / ankur gupta

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

find highest salary..

Answer / richa

$P = shell_exec("SELECT salary
FROM mytable
ORDER BY
salary DESC");
echo $p[0];

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More PHP Interview Questions

What is difference Between PHP 5 and 7?

0 Answers  


Which is useful for method overloading?

0 Answers  


What are the three classes of errors that can occur in php?

0 Answers  


How to upload file in php?

0 Answers  


What is substr in php?

0 Answers  






What types of loops exist in php?

0 Answers  


What is an associative array?

0 Answers  


What are the different ways to login to a remote server? Explain the means, advantages and disadvantages?

1 Answers  


How to make a file encrypt and decrypt?

4 Answers   3i Infotech,


What are php magic methods/functions?

0 Answers  


What is the difference between exception::getmessage and exception::getline?

0 Answers  


How to get number of elements in an array?

0 Answers  


Categories