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

How do you identify a primary key?

1034

---

What is difference between my sql and sql?

1023

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

986

---

difference between anonymous blocks and sub-programs.

1097

---

What is trigger price?

944

---

What are sql functions? Describe in brief different types of sql functions?

1045

---

How to get list of all tables from a database?

1125

---

What is Materialized View? In What Scenario we Use Materialized View?

9446

---

how is exception handling handled in mysql? : Sql dba

1032

---

What is the difference between an inner and outer join?

984

---

How to run sql*plus commands in sql developer?

1107

---

What is the main difference between sql and pl/sql?

1050

---

How do I delete a trigger?

931

---

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

950

---

Mention what are different methods to trace the pl/sql code?

1146

---