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  

---

Explain nested join?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  

---

What is a raid and what are different types of raid configurations?

0 Answers  

---

How to truncate the log in sql server 2012? : sql server database administration

0 Answers  

---

plz send every query in sql server2000

1 Answers   Infosys,

---

What are the tool windows in sql server management studio? : sql server management studio

0 Answers  

---

What is difference between after and before?

0 Answers  

---

What is sql view?

0 Answers  

---

what is procedure in sql?

2 Answers   Millennium, SQL,

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---