one table has four field id,name,design,salary. i have to
find maximum salary .
- 6 Answers
- 6570 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
How to test values returned by a subquery with the in operator?
what is a traditional network library for sql servers? : Sql server database administration
What is the openxml statement in sql server?
Which tcp/ip port does the sql server run on? How can it be changed?
How does recursive cte works in sql server?
Explain throw statement in sql server 2008?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Characterize join and name diverse sorts of joins?
What happens if you are trying to access a schema not owned by you?
How do you test your database? : sql server database administration
Explain the steps to create and execute a user-defined function in the sql server?
can a database be shrunk with users active? : Sql server administration
What’s the distinction between dropping a info and taking a info offline?
What is meant by indexing?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
