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

Can we alter stored procedure?

1042

What are the different set operators available in sql?

1080

What are the disadvantages of file system?

1359

what are string data types? : Sql dba

1093

when MSQL8.0 is in market

2141

What is trigger types of trigger?

1144

Is not null in sql?

1045

What mean sql?

1054

What is the left table in sql?

1015

What is sql used for?

1165

In a distributed database system, can we execute two queries simultaneously?

1155

What do you mean by stored procedures?

1069

Which data type is a composite type?

1037

How to assign sql query results to pl sql variables?

1146

What is percent sign in sql?

1324