Answer Posted / sixface

ID NAME
1 ravi
2 umang
1 ravi
3 nishant

SELECT id,name
FROM emp
WHERE id in
(
SELECT id
FROM emp
GROUP BY id
HAVING COUNT(*) > 1
);
It gives all duplicate rows........
Lets try.....

Is like operator in sql case sensitive?

999

---

what is dbms? : Sql dba

972

---

What is orm in sql?

1030

---

What is the difference among union, minus and intersect?

982

---

Is left join faster than join?

1029

---

How to write pl sql program in mysql command prompt?

1067

---

What is java sql package?

1072

---

How does sql*loader handles newline characters in a record? : aql loader

1021

---

How can you load microsoft excel data into oracle? : aql loader

1153

---

What is sqlservr exe?

964

---

How exception is different from error?

1002

---

What does plv msg allows you to do?

1121

---

Why function is used in sql?

923

---

What is sql clause?

1033

---

Do we need to create index on primary key?

903

---