employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

Can we use where clause with group by?

0 Answers  

---

What is view in sql?

0 Answers  

---

What are the differences between char and varchar in ms sql server?

0 Answers  

---

Explain what is the purpose of sql profiler in sql server?

0 Answers  

---

What do you understand by recursive stored procedure?

0 Answers  

---

Explain comment on transactions?

0 Answers  

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

---

How to list all login names on the ms sql server?

0 Answers  

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---