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

check whether all the emp numbers are indeed unique.

Question Posted / biswajit rout

Answer Posted / biswajit rout

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the size of partition table?

1027

Is foreign key mandatory?

985

Can we create index on primary key?

949

How run sql*plus commands that are stored in a local file?

1035

What is percent sign in sql?

1263

Does access use sql?

1018

what are date and time functions in mysql? : Sql dba

963

What is the difference between microsoft sql and mysql?

950

Can we rollback after truncate?

1012

What are the different types of dbms?

994

What is sql indexing?

998

Explain normalization and what are the advantages of it?

938

How do I count rows in sql query?

973

How to get unique records from a table?

941

Why stored procedure is better than query?

923