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
- 51933 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / aravind
select SPAN_UUID, SPAN_UNIT_UUID, count(*) from
SPAN_SPAN_UNIT group by SPAN_UUID, SPAN_UNIT_UUID having
count(*) > 1;
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
List and explain the different types of join clauses supported in ansi-standard sql?
What is date functions?
What is lookup table in sql?
What is left join in sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is memory optimized?
How do you update f as m and m as f from the below table testtable?
What kind of join is join?
What is the difference between view and stored procedure?
How do you write a subquery?
what is heap table? : Sql dba
Difference between truncate, delete and drop commands?
What is sql profiler in oracle?
What is sql basics?
What are pl/sql cursors?
