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 does varchar include?

952

What is procedure in pl sql?

1046

What is parallel hint?

1328

What is a data definition language?

1133

How to add, remove, modify users using sql?

1038

What are views in sql?

989

What are the limitations of sql express?

1071

Does sql*plus have a pl/sql engine?

1075

What is the importance of sqlcode and sqlerrm?

1356

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

1100

What are expressions?

1015

How do you determine the current isolation level? : Transact sql

1158

Explain ttitle and btitle.

1119

What are the sql aggregate functions?

1133

What is sql and its types?

1192