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
Explain different forms of normalization?
How to backup encryption key ?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What does sql server mean?
Does an index slow down updates on indexed columns?
Can two tables share a primary key?
How you can get the list of largest tables in a database?
What is the difference between coalesce() & isnull()?
How to create an index on a view?
How is a full-text index updated?
What is data source in connection string?
What is the maximum row of a size?
What is RMS migrations?
How to call stored procedure using http soap?
What is a partitioned view?