Answer Posted / sravan

Hi here is another way to solve this

SELECT NAME, COUNT(NAME) FROM TABLE_NAME
WHERE NAME IN (SELECT NAME FROM TABLE_NAME
GROUP BY NAME
HAVING COUNT(NAME)>1)
GROUP BY NAME;

thanks

what is commit? : Sql dba

1080

---

How do you use a while loop in pl sql?

1015

---

How many sectors are in a partition?

1076

---

How to get help at the sql prompt?

1119

---

How many types of normalization are there?

966

---

What does trigger mean in slang?

1066

---

how to run 'mysql' commands from a batch file? : Sql dba

1121

---

How is indexing done in search engines?

982

---

Explain what is rdbms?

1042

---

what is a tablespace? : Sql dba

1057

---

Write the alter statement to enable all the triggers on the t.students table.

1126

---

Explain architecture of sql server notification services?

1063

---

What are sql indexes?

1004

---

How are sql commands classified?

1092

---

What is dba in sql? : SQL DBA

1045

---