check whether all the emp numbers are indeed unique.

Answer Posted / biswajit rout

SELECT empno,count(*) FROM emp GROUP BY empno;

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I order columns in sql?

619


Where can I learn sql for free?

603


How to run sql commands in sql*plus?

684


what are the properties and different types of sub-queries? : Sql dba

609


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

683






How to read xml file in oracle pl sql?

601


What is the left table in sql?

599


Is left join same as join?

616


what is sql? : Sql dba

647


How do I trace sql profiler?

596


What is use of term?

716


What is a primary key called that is made up of more than one field?

900


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

718


what are the type of locks ? : Sql dba

633


what are all the different normalizations? : Sql dba

599