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
- 7639 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
If user is owning any SQL Objects, can we drop that user
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What happens if null values are involved in comparison operations?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is the library index called?
Can I work with several databases simultaneously? : sql server management studio
Write a SQL query to make a column as unique?
What is a covered index?
How sql server executes a statement with nested subqueries?
What is normalization? Describe its different types.
Explain transaction server consistency?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is merge statement?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Write a sql query to delete duplicate records from a table called table1
