Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 5617 Views
- I also Faced
- E-Mail Answers
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 how dts is used to extract, transform and consolidate data?
Are connections to sql server encrypted?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is set nocount on?
Explain what are the different index configurations a table can have?
What is the use of sign function?
How do you use a subquery to find records that exist in one table and do not exist in another?
What are the different acid properties?
What is for xml in sql server?
What is rolap and its advantage? : sql server analysis services, ssas
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
How many types of database relationship in sql server?
What is ms sql server triggers?
What is the distinction amongst delete and truncate?
What are the underflow and overflow behaviors on float literals?
