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  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

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

7 Answers  

---

Explain the database you used in your final year project?

0 Answers   Wipro,

---

What is a partitioned view?

0 Answers  

---

What happens if null values are involved in comparison operations?

0 Answers  

---

what is difference between having and where clause ?

3 Answers  

---

What are the methods used to protect against sql injection attack?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

How to find the service pack installed? : sql server database administration

0 Answers  

---

Can you get second highest salary from the table?

0 Answers   QuestPond,

---

What are different types of statements that are supported by sql?

0 Answers  

---