Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table?
- 29 Answers
- 51105 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / lavanya
SELECT COUNT(*), <COLUMN_NAME> FROM EDUCATION GROUP BY
<COLUMN_NAME>
| Is This Answer Correct ? | 10 Yes | 14 No |
Post New Answer View All Answers
Is it possible to create the following trigger: before or after update trigger for each row?
What packages are available to pl/sql developers?
Mention what pl/sql package consists of?
What is the difference between functions, procedures, and packages in pl/sql?
Which software is used for pl sql programming?
Does a primary key have to be a number?
What does an inner join do?
What is a call statement? Explain with an example.
What is bind reference and how can it be created?
Does sap use sql?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
How to get each name only once from an employee table?
What is rename command in sql?
Can sql function call stored procedure?
What is substitution variable in pl sql?
