Answer / sunil kumar

select max(salary) from tablename

Answer / ritu

select max(salary) from tablename

Answer / subhra

select max(salary) from table_name;

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 )

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 )

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 )

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.

Answer / richa

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

where to change in php.ini file for file uploading?

1 Answers  

What is symfony php?

0 Answers  

am fresher in php ..am finished my linux,apache,mysql,and php(LAMP) course please can any one tell openings for freshers in php ...And please tell how much i demand as a fresher in PHP field just say approximately or assumption ..? at present am staying in chennai am looking my job in chennai only or else in bangalore ... hello experts please answer this question ?

2 Answers   HCL,

Can you convert php to html?

0 Answers  

How to get ip address of a server in php?

0 Answers  

How to replace a text in a string with another text in php?

0 Answers  

at present am learning lamp course sir ..i want to know the carrer prospectus in php ...is there any companies recruiting freshers in chennai ..for freshers how much can i demand as a fresher in php ....?i finished my mca ..please sugggest me to face interview in php asking salary details and all please suggest me how much can i ask as a fresher in php ? and also tel is there any openings in chennai for recruting php freshers send their emails and company info please ? please send ur valuable suggestions to kiranpulsar2007@gmail.com i hope u wil reply to my question thank u guys bye take care see u soon all the best to everyone

1 Answers   Microsoft, Satyam,

What is empty php?

0 Answers  

Tips to optimize the php script..... Suggestion for exception handling in php...

1 Answers  

How to create and destroy cookies in php?

0 Answers  

What is faster in php?

0 Answers  

How can we check the value of a given variable is a number?

0 Answers