how do you count the duplicate records in a table
Answer Posted / purushotham
select column,count(1) from a
group by column
having count(1)>1;
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
what's the difference between a primary key and a unique key? : Sql dba
How to pipe multiline string to isql?
What are the different tcl commands in sql?
What are the constraints available in sql?
how to rename an existing table in mysql? : Sql dba
What does the file extension accdb stand for?
How do I run a program in pl sql?
How many sql statements are used?
Name the operator which is used in the query for pattern matching?
How do I run a script in sql developer?
What does a pl/sql package consist of?
what is column? : Sql dba
What is difference between joins and union?