one table has four field id,name,design,salary. i have to
find maximum salary .
Answers were Sorted based on User's Feedback
Answer / prashant
Select * from table1 where salary = (select max(salary)
from table1)
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 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 |
What is buffer cash in sql server?
What is normalization?
Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.
explain different types of cursors? : Sql server database administration
What is a transact-sql statement batch in ms sql server?
What is spid in sql server profiler?
What is data compression? : sql server database administration
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?
Is truncate a dml command?
what are the joins,primary key,foriegn key, candidate key, super key and expain them?
How can you see what type of locks used?
What are sub-queries? Give example? In which case sub-queries are not feasible?