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

check whether all the emp numbers are indeed unique.

Question Posted / biswajit rout

6 Answers
17453 Views
I also Faced
E-Mail Answers

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 to extract a unit value from a date and time? : Sql dba

948

Can we use delete in merge statement?

1002

What is the difference between union and union all command?

1009

What are its different types of dbms?

957

How do I find sql profiler?

886

How do I tune a sql query?

936

What is pl sql script?

979

what is the difference between undefined value and null value? : Sql dba

1041

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1536

Explain the difference between rename and alias?

966

Can we insert data into view?

850

what is try_catch block in procedure

1659

What is dynamic query?

915

What is posting?

990

how can you create an empty table from an existing table? : Sql dba

1080