check whether all the emp numbers are indeed unique.
- 6 Answers
- 15460 Views
- I also Faced
- E-Mail Answers
Answer Posted / valli
select rowid from (
select emp_no, rownum() over (emp_no) as Rownum
from emp order_by emp_no,sal
) where rownum > 2
If this query returns no rows then we can say all the emp
numbers are indeed unique.
Regard,
Valli
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Who is the owner of mysql database?
What is difference between mysql and postgresql?
What is snowflake sql?
What are tuples in sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
Is keyword pl sql?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is transaction control language (tcl)?
What is the main reason behind using an index?
Explain normalization and what are the advantages of it?
What are some emotional triggers?
What is interval partition?
What is embedded sql in db2?
When sql appeared?
what is a trigger in mysql? Define different types of trigger. : Sql dba
