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.....

what is denormalization. : Sql dba

1042

---

How can we optimize a sql query?

982

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

---

Explain the select statement in sql?

1044

---

how do you control the max size of a heap table? : Sql dba

921

---

What is the maximum number of columns in sql table?

1088

---

How delete a row in sql?

926

---

Is record in oracle pl sql?

902

---

What does the acronym acid stand for in database management?

983

---

how to calculate expressions with sql statements? : Sql dba

980

---

How do I upgrade sql?

947

---

How do you optimize a stored procedure in sql?

893

---

How do you declare a user-defined exception?

962

---

How do you explain an index number?

1022

---

What are the datatypes available in pl/sql ?

1043

---