find highest salary

Categories >> Software >> Programming Languages >> PHP Related >> PHP
Suggest New Category

find highest salary

Question Posted / subashvns

8 Answers
8303 Views
I also Faced
E-Mail Answers

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