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

what is the difference between group by and order by in sql? : Sql dba

1188

What is not null in sql?

1109

Show code of a cursor for loop.

1113

Why do we need databases?

1093

Can a commit statement be executed as part of a trigger?

1105

What is difference between ms sql and mysql?

1016

what are date and time functions in mysql? : Sql dba

1028

what is “go” in t-sql? : Transact sql

1158

tell me about various levels of constraint. : Sql dba

1077

What is a primary key example?

1003

what is the difference between primary key and unique key? : Sql dba

1086

What is a clob in sql?

1066

Can we change the table name in sql?

1005

What is the difference between inner join and left join?

1041

What is sqlservr exe?

1029