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
How many types of tables are there?
What is the maximum number of rows in sql table?
How do I delete a trigger?
Which is faster union or join?
What are sql constraints?
What operators deal with null?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is hibernate and its relation to sql?
What is pivot in sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is record data type?
what is the difference between truncate and drop statements? : Sql dba
who introduced sql?
What is the best sql course?
how to convert dates to character strings? : Sql dba