I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?
- 5 Answers
- 7820 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / vikas
select *
from a
where rowid not in (select min(rowid) from a group by no)
no is column in table a;
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
WHAT IS ecc 6.0
What happens if the imported table already exists?
How to convert characters to numbers in oracle?
What is the order of defining local variables and sub procedures/functions?
How to define a variable of a specific record type?
How do you find current date and time in oracle?
What are the types of partitions in oracle?
How to drop a stored procedure in oracle?
How do you bind variables in oracle?
How to run queries on external tables?
How to handle a single quote in oracle sql?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is the usage of save points in oracle database?
How to open a cursor variable?
What exactly do quotation marks around the table name do?
