one table has four field id,name,design,salary. i have to
find maximum salary .
Answer Posted / ashish
hi,, it work
select * from table where salary =(select max(salary) from
table) .......this returns whole record of that salary,,,,
an if u want just that maximum salary than
select max(salary) from table
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What happens if you delete a table that is used by a view?
How to rebuild indexes with alter index ... Rebuild?
What is the beast way to write CTE in SQL Server ?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
what authentication modes does sql server support? : Sql server database administration
What is the difference between ddl,dml and dcl commands?
How do you create type- insensitive operator?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
what protocol both networks use? : Sql server database administration
What is a partition key?
Can we update data in a view?
What is blocking and how would you troubleshoot it? : sql server database administration
How to create an index on a view?
What is ddl command?
How to implement service broker?