Name Salary Abc 50000 Abc 50000 xyz 20000 find the max sal

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

Question Posted / guest

2 Answers
10515 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / prashant

select max(salary) from
(select distinct(salary) from ABC)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

Why should I use postgresql?

0 Answers

What are local and global variables and their differences?

0 Answers

Does execute immediate commit?

0 Answers

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers

What's the difference between inner join and left join?

0 Answers

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers

What is the best partition size for windows 10?

0 Answers

What is the difference between anonymous block and named blocks?

3 Answers

What is synonyms?

0 Answers

What is embedded sql with example?