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

Can you have more than one trigger on a table?

708


How does index help in query performance?

761


Why is pl sql used?

687


What is the maximum rows in csv?

645


What is the use of index in hive?

727






Differentiate between syntax and runtime errors.

844


What has stored procedures in sql?

779


What is insert command in sql?

769


what is a database transaction? : Sql dba

822


How do I save a sql query?

731


What is the difference between the implicit and explicit cursors?

742


What is cursor in pl sql with examples?

672


what are sequences

1315


What is a subquery in sql?

694


What is the size of partition table?

740