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
- 7632 Views
- I also Faced
- E-Mail Answers
Answer Posted / prashant
Select * from table1 where salary = (select max(salary)
from table1)
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Explain what is lock escalation?
What is SubQuery in SQL Server 2008
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Explain subquery and state its properties?
Explain atomicity?
Do you know what are acid properties?
How to create a view using data from another view?
How do I know if localdb is running?
What is trace flag in sql server?
What is merge replication?
what is the difference between Delete and Truncate command in SQL
How to reaname table name without using sp_Rename in sql server..?
Explain transaction server auto commit?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is normalization and what are the advantages of it?
