check whether all the emp numbers are indeed unique.
- 6 Answers
- 16467 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
What is before and after trigger?
What are sql data types?
Why truncate is used in sql?
How many row comparison operators are used while working with a subquery?
What are the advantages of sql? Explain
What is t sql in sql server?
What is sqlcommand?
What is schema in sql example?
Do we need to rebuild index after truncate?
What is the difference between between and in condition operators?
What is sqlca in powerbuilder?
What are user defined functions?
what is subquery? : Sql dba
Why is sql important?
Where not exists in sql?
