check whether all the emp numbers are indeed unique.
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
Why is a primary key important?
What is a common use of group by in sql?
Can sql developer connect to db2?
Which join condition can be specified using on clause?
how to create a test table in your mysql server? : Sql dba
What is sqlca in db2?
Why cross join is used?
what is log shipping? : Sql dba
how can we find the number of rows in a table using mysql? : Sql dba
What is rank function in sql?
Are dml statements autocommit?
What can you do with pl sql?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Can you select everything, but 1 or 2 fields, without writer's cramp?
How does postgresql compare to mysql?