SELECT DISTINCT(ENAME) FROM EMP;

What is the Query to print out the individual total number of
duplicate row in sql.

Question Posted / ahmad

Answer Posted / ahmad

Is This Answer Correct ?

1 Yes

24 No

Please Help Members By Posting Answers For Below Questions

What is sap sql?

1028

If a cursor is open, how can we find in a pl/sql block?

1213

How can I change database name in sql?

1156

Is record in pl sql?

1012

Is progress software supports to ( pl/sql )?

1093

What is anonymous block in sql?

1170

What is a unique key?

1103

What is the difference between drop and truncate commands?

1110

How delete a row in sql?

1040

What is pl sql block structure?

1091

What is nosql example?

1089

What is normalization? How many normalization forms are there?

1138

Why join is faster than subquery?

1159

Is it mandatory for the primary key to be given a value when a new record is inserted?

1251

How do rank () and dense_rank () differ?

1105