Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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  


Categories