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 the difference between stored procedure and view?

962

---

What are different sql data types?

951

---

How to return multiple rows from the stored procedure?

912

---

What is character functions?

1014

---

how to use like conditions? : Sql dba

1036

---

how to decrement dates by 1 in mysql? : Sql dba

967

---

What is raw datatype in sql?

976

---

How many types of relationship are there?

973

---

Why do we need cursor in pl sql?

1078

---

What is an ndf file?

926

---

Why do we use cursors?

918

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2069

---

How to connect a sql*plus session to an oracle server?

1079

---

How do you add a column to a table?

992

---

Why do we need view in sql?

931

---