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 process of debugging?

1080

What is the difference between view and stored procedure?

964

Explain spool.

1186

Explain the purpose of %type and %rowtype data types with the example?

1001

What is the starting oracle error number? What is meant by forward declaration in functions?

1004

What are the different datatypes available in PL/SQL?

1092

What is embedded sql what are its advantages?

1049

How do you use collections in procedure to return the resultset?

2248

Can we create view in stored procedure?

982

Is oracel sql developer written in java?

1127

What is the use of sqldataadapter?

982

how to present a past time in hours, minutes and seconds? : Sql dba

1018

Does a primary key have to be a number?

971

How do you explain an index number?

1116

what is a table in a database ? : Sql dba

1050