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
Answer Posted / maulesh
Select Deptname
From Department
Where salary >=5000
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is use of except clause? How it differs from not in clause?
How to optimize stored procedure optimization?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What are transactions and its controls?
Differentiate between a local and a global temporary table?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is inline variable assignment?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Indexes are updated automatically is the full-text index also updated automatically?
How can you start sql server in different modes?
Explain Geometry datatype in sql server 2008 with example
Can a rule be bound to any column of any data type?
What are the benefits and tasks of object explorer? : sql server management studio
What is shrink log file?
What are the properties of the transaction?