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  

---

What is an index?

8 Answers   Yardi Software,

---

What is the exact numeric data type in sql?

0 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

What do you understand by recursive stored procedures?

0 Answers  

---

What is a join and their types?

2 Answers   Challenger Financial,

---

How to write a query with a right outer join in ms sql server?

0 Answers  

---

Does partitioning help performance?

0 Answers  

---

How can we determine what objects a user-defined function depends upon?

0 Answers  

---

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 Answers  

---

What is indexed view? How to create it?

0 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---