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
Answers were Sorted based on User's Feedback
Answer / maulesh
Select Deptname
From Department
Where salary >=5000
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / rajkumar
Select Deptname from Department Where salary >=5000
Is This Answer Correct ? | 1 Yes | 0 No |
what is replication? where do u use Go Keyword?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Is there any difference between the primary key and unique key?
What is Self Join?
After the SQL installation what are the jobs will you configure?
1 Answers G7 CR Technologies, IBM, Satyam,
Which is the best place or learning center for MS SQL?????In Bangladesh?????
how to find 6th highest salary
How to check table values in sql server?
What is a SQL Server Temporary Table?
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
can you any body tell me the difference between candidate key and primary key
Difference between aggregate functions of sql?