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
- 7458 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 happens if you add a new index to large table?
What are rest-style architecture's?
Explain what are the restrictions while creating batches in sql server?
Give an example of why you would want to denormalize a database
Explain the properties of a relational table?
What the different components of Replication and what is their use?
What are the difference between “where” and “having” clause in sql server?
How can delete duplicate records in cte in sql server?
Explain index in sql server?
How can you insert values in multiple rows using one Insert statement?
Is port 1433 secure?
What is database dimension? : sql server analysis services, ssas
What is DCL?
Explain rdbms?
Explain about local stored procedure?
