Interested to Buy Any Domain ? << Click Here >> for more details...
one table has four field id,name,design,salary. i have to
find maximum salary .
- 6 Answers
- 7937 Views
- I also Faced
- E-Mail Answers
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 is Cross Join and in which scenario do we use Cross Join?
In which sql server version report builder introduced?
What do you know about normalization and de- normalization?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
Which is better statement or preparedstatement?
How to find the source of a table in sql server?
How to find Duplicate Records In table?
What is data compression? : sql server database administration
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
How to see the event list of an existing trigger using sys.trigger_events?
Name the different type of indexes in sql?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What does select 1 mean?
Do comments need to go in a special place in sql server 2005?
how to trace the traffic hitting a sql server? : Sql server database administration
