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

check whether all the emp numbers are indeed unique.

Question Posted / biswajit rout

6 Answers
15435 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

What are the different sql commands?

505

What is the execution plan in sql?

549

Can we use insert statement in function?

510

What is trigger with example?

555

Show the two pl/sql cursor exceptions.

605

What is use of term?

614

How do I view a sql trace file?

556

Does sql view stored data?

528

Explain what is a database?

641

What is clause?

604

How to read/write files from pl/sql?

576

What are different types of keys?

517

what is 'mysqlcheck'? : Sql dba

563

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1636

What are the types of sql commands?

544