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 are types of indexes in sql?

1065

---

What is sqlite used for?

982

---

What trigger means?

968

---

Differentiate between sga and pga.

1146

---

How do I clear the screen in sql plus?

1033

---

What are tables and fields?

1019

---

How do you create a unique index?

1036

---

What are the advantages of stored procedure?

994

---

define join and explain different type of joins? : Sql dba

936

---

Can we group by two columns in sql?

972

---

What are the dml statements?

1134

---

What is the use of procedures?

965

---

How do I copy a table in sql?

969

---

what are the different tables present in mysql? : Sql dba

963

---

List the ways to get the count of records in a table?

896

---