Name Salary
Abc 50000
Abc 50000
xyz 20000
find the max salary using aggregate function?
Answer Posted / prashant
select max(salary) from
(select distinct(salary) from ABC)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
How to use sql*plus built-in timers?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is data type in sql?
What is oracle pl sql developer?
What is the file extension for sql database?
What is cost in sql execution plan?
Which type of cursor is used to execute the dml statement?
What is rownum?
What is sqlservr exe?
What does <> sql mean?
What is the use of count (*) in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Mention what is the use of function "module procedure" in pl/sql?
what is the difference between a having clause and a where clause? : Sql dba