1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Department
-----------
salary Deptname
1000 A
3000 A
2000 B
3000 B
4000 C
5000 C

select the deptname where salary >=5000

result should be:
Deptname
---------
C

please post only executed query in SQL server 2005
Asked By: Md. Niyaz

Question Posted / rajkumar

Answer Posted / rajkumar

Select Deptname from Department Where salary >=5000

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List all the types of user-defined functions?

533

what is the difference between delete table and truncate table commands? : Sql server database administration

531

What are page splits? : SQL Server Architecture

548

Mention the differences between local and global temporary tables.

575

What are the lambda triggers?

495




What is default port number for sql server 2000?

610

Do I need a report server to run reports in my application?

106

What are the requirements to use odbc connections in php scripts?

607

Should you normalize audio?

537

What functions can a view be used to performed?

630

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1563

What is BLOCK statements in SQL?

813

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

528

What is change data capture (cdc) feature?

602

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

587