check whether all the emp numbers are indeed unique.

Answer Posted / suresh somayajula

in rownum we will use < or <= operators only.

If any one knows this query pls send the answer.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What pl/sql package consists of?

835


What does 0 mean in sql?

694


How can I delete duplicate rows?

738


what are the differences between char and nchar? : Sql dba

797


What are %type and %rowtype for?

808






Can you have more than one key in a database?

686


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

663


explain the advantages and disadvantages of stored procedure? : Sql dba

709


Why do we need cursors in pl sql?

719


Is pl sql different from sql?

717


What is the usage of the distinct keyword?

889


Explain raise_application_error.

829


What is a unique key?

773


What do you mean by stored procedures?

732


Can variables be used in sql statements?

747