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

Explain the the update statement in sql?

770


What is implicit cursor in pl sql?

739


How to use sql*plus built-in timers?

768


Is join an inner join?

718


Is pl sql better than sql?

719






How to avoid using cursors? What to use instead of cursor and in what cases to do so?

870


What is column?

723


What are all the different types of indexes?

814


How do I clear the screen in sql plus?

756


What is the size of partition table?

742


What is sql performance tuning?

652


What is native sql query?

738


How do you optimize a query?

733


how to get a list of indexes of an existing table? : Sql dba

713


What is graph sql?

721