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

How is use pl and sql?

1073

what does the t-sql command ident_incr does? : Transact sql

1088

what are all types of user defined functions? : Sql dba

1051

What are transaction and its controls?

1049

How to fetch alternate records from a table?

1256

What is pragma in pl sql?

1120

Explain what is rdbms?

1049

Is there a 64 bit version of ssms?

967

How does cross join work?

965

What is sql dialect?

1126

What is dynamic sql in pl sql?

1044

What are literals in sql server?

1183

What is trigger point?

1002

Can procedure in package be overloaded?

1093

What is pl sql commands?

1054