select max(sal) from tab_name; or select * from tab

Name Salary
Abc 50000
Abc 50000
xyz 20000
find the max salary using aggregate function?

Question Posted / guest

Answer Posted / guest

select max(sal) from tab_name;
or
select * from tab_name where sal=(select max(sal) from
tab_name) and rownum<=1;

Is This Answer Correct ?

20 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is big data nosql?

942

Are left and right joins the same?

1078

What is sql injection vulnerability?

940

What is lookup table in sql?

1040

Define select, insert, create, delete, update, drop keywords

1044

Is sql scripting language?

1048

how to shutdown mysql server? : Sql dba

1095

Why is pl sql used?

976

Does access use sql?

1037

What is the difference between numeric and autonumber?

995

what are the differences between char and nchar? : Sql dba

1113

Can triggers stop a dml statement from executing on a table?

1085

Is sql procedural language?

962

What is mutating error in pl sql?

1013

What kind of join is join?

960