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


Please Help Members By Posting Answers For Below Questions

How many types of tables are there?

694


What is the maximum number of rows in sql table?

743


How do I delete a trigger?

723


Which is faster union or join?

702


What are sql constraints?

788






What operators deal with null?

813


The select into statement is most often used to create backup copies of tables or for archiving records?

770


What is hibernate and its relation to sql?

789


What is pivot in sql?

670


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

869


What is record data type?

677


what is the difference between truncate and drop statements? : Sql dba

745


who introduced sql?

752


What is the best sql course?

720


how to convert dates to character strings? : Sql dba

734