i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

What is a join and their types?

2 Answers   Challenger Financial,

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

What are the advantages of passing name-value pairs as parameters?

0 Answers  

---

---

how to implement locking in sql server

3 Answers   Satyam,

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

optimization techinques

0 Answers   Wipro,

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

Do you know what is openxml in sql server?

0 Answers  

---

Explain what is it unwise to create wide clustered index keys?

0 Answers  

---

Does partitioning improve performance?

0 Answers  

---