write a query to get maximum salary from the employers table without duplicates

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

write a query to get maximum salary from the employers table
without duplicates....kindly help me

Question Posted / baladevshree

5 Answers
10043 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write a query to get maximum salary from the employers table without duplicates....kindly help me..

Answer / rama

select (distinct max(sal)) from emp

Is This Answer Correct ?

16 Yes

7 No

write a query to get maximum salary from the employers table without duplicates....kindly help me..

Answer / sudheer113

MAX(SAL) will not give duplicate records in a single group

Is This Answer Correct ?

1 Yes

0 No

write a query to get maximum salary from the employers table without duplicates....kindly help me..

Answer / anil kumar

select distinct max(sal) from table name

Is This Answer Correct ?

2 Yes

5 No

write a query to get maximum salary from the employers table without duplicates....kindly help me..

Answer / deva

select (distinct max(sal)) from emp
group by sal.

When ever you use goupfunctions in select statement grup by clause is must.....other wise it will throw an error

Is This Answer Correct ?

8 Yes

13 No

write a query to get maximum salary from the employers table without duplicates....kindly help me..

Answer / asdfg

select (distinct max(sal)) from emp
group by sal.

When ever you use goupfunctions in select statement grup by
clause is must.....other wise it will throw an error

Is This Answer Correct ?

0 Yes

9 No

Post New Answer