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];

Suppose we receive a form submitted by a post to subscribe to a newsletter. This form has only one field, an input text field named email. How would we validate whether the field is empty? Print a message "the email cannot be empty" in this case?

0 Answers  

What are the differences between mysqli_connect and mysqli_pconnect?

0 Answers  

Write a statement to show the joining of multiple comparisons in php?

0 Answers  

To find out the current year is leap year or not which date() function we've to use.Give the syntax also

5 Answers  

What is phpsessid?

0 Answers  

How can we register the variables into a Session?

7 Answers   HCL, Star Computers, Trikon Networks,

Explain Constant in Class?

0 Answers  

Explain about Functions in PHP?

1 Answers  

What is the difference between == and === operator in PHP?

0 Answers  

Do you know when sessions ends?

0 Answers  

can anyone explain oops concept in php or give website to learn this concept clearly?

2 Answers   Nadsoft, Satyam,

Is php easier than node?

0 Answers