Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Query to print out the individual total number of
duplicate row in sql.
- 5 Answers
- 11899 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / raveendran
SQL>select * from a;
A B
---- -------------------------
1 Name
ABC
BCA
fdhgjdshfj
3 Name
ABC
BCA
fdhgjdshfj
2 Name
ABC
BCA
fdhgjdshfj
4 Name
ABC
BCA
fdhgjdshfj
5 asd
A B
---- -------------------------
asd
asd
asdd
6 asd
asd
7 asd asd
8 asd asd
sql>select count(b),b from a group by b having count(b)>=1;
T(B) B
---- -------------------------
4 Name
ABC
BCA
fdhgjdshfj
1 asd
asd
1 asd
asd
asd
asdd
2 asd asd
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the different schemas objects that can be created using pl/sql?
Is pl sql and postgresql same?
how to convert character strings to numeric values? : Sql dba
Which is better stored procedure or query?
what are aggregate and scalar functions? : Sql dba
What pl/sql package consists of?
how to decrement dates by 1 in mysql? : Sql dba
Why stored procedure is better than query?
Write the command to remove all players named sachin from the players table.
Can we connect to postgresql using sql developer?
Is record in pl sql?
How do you explain an index?
what are integrity rules?
when is the use of update_statistics command? : Sql dba
What is transaction control language (tcl)?
