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

Do foreign keys improve performance?

1022

How do I run a sql trace?

957

what are the differences between require and include, include_once and require_once? : Sql dba

1020

What type of database is cloud sql?

1100

How can a pl sql block be executed?

944

what is auto increment? : Sql dba

1008

What are the types pl/sql code blocks?

1127

How do you declare a constant?

960

How to add new employee details in an employee_details table with the following details

1091

What is rename in sql?

972

What are triggers in sql?

1020

What is scope and visibility in PL/SQL?

1204

How can you save or place your msg in a table?

1001

Enlist the advantages of sql.

1001

What does select count (*) mean in sql?

1018