Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 / mdniyaz.ahmad

Answers were Sorted based on User's Feedback



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

Answer / maulesh

Select Deptname
From Department
Where salary >=5000

Is This Answer Correct ?    10 Yes 0 No

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

Answer / praveen s

C

Is This Answer Correct ?    6 Yes 1 No

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

Answer / rajkumar

Select Deptname from Department Where salary >=5000

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

what are the Prerequisites for Replication?

1 Answers   IBM,

What is sub-query in sql server? Explain its properties.

0 Answers  

Define ACID properties in a Database?

0 Answers   iNautix,

Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

CREATE a table from another table

2 Answers  

Describe in brief system database.

0 Answers  

what kind of lan types do you know? : Sql server database administration

0 Answers  

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

what is IDE,DMV in sql server?

1 Answers   Value Labs,

Why do we need normalization?

0 Answers  

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

0 Answers  

what is normalization? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories