one table has four field id,name,design,salary. i have to find maximum salary

Categories >> Software >> Databases >> SQL Server
Suggest New Category

one table has four field id,name,design,salary. i have to
find maximum salary .

Question Posted / guest

6 Answers
5846 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

one table has four field id,name,design,salary. i have to find maximum salary ...

Answer / sujit

select max(sal) from <tablename>
if this answer not correct plz give me commets on the answer

Is This Answer Correct ?

13 Yes

2 No

one table has four field id,name,design,salary. i have to find maximum salary ...

Answer / prashant

Select * from table1 where salary = (select max(salary)
from table1)

Is This Answer Correct ?

8 Yes

0 No

one table has four field id,name,design,salary. i have to find maximum salary ...

Answer / ashish

hi,, it work

select * from table where salary =(select max(salary) from
table) .......this returns whole record of that salary,,,,
an if u want just that maximum salary than

select max(salary) from table

Is This Answer Correct ?

6 Yes

0 No

one table has four field id,name,design,salary. i have to find maximum salary ...

Answer / elumalai.k

select max(salary) from tablename

Is This Answer Correct ?

4 Yes

0 No

one table has four field id,name,design,salary. i have to find maximum salary ...

Answer / soni

SELECT MAX(columnName1)
FROM Employee

Is This Answer Correct ?

3 Yes

1 No

one table has four field id,name,design,salary. i have to find maximum salary ...

Answer / guest

select * from tab where max(salary)

Is This Answer Correct ?

4 Yes

8 No

Post New Answer