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

Answer Posted / ahmad

SELECT DISTINCT(ENAME) FROM EMP;

Is This Answer Correct ?    1 Yes 24 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we update views in sql?

531


What is clause in sql?

579


What is time based sql injection?

486


What is query syntax?

519


What are the two types of exceptions.

631






how to calculate expressions with sql statements? : Sql dba

524


how to see the create table statement of an existing table? : Sql dba

521


Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

532


Which join is like an inner join?

523


What is sql*loader?

568


What kind of join is join?

555


What is partition in sql query?

515


What is a heap in sql?

526


How do you truncate?

503


what is dbms? : Sql dba

541