Interested to Buy Any Domain ? << Click Here >> for more details...
check whether all the emp numbers are indeed unique.
- 6 Answers
- 17618 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
Can a foreign key be a duplicate?
What is record data type?
Are stored procedures faster than dynamic sql?
Why is sql better than hql?
Explain the types of joins in sql?
How can I speed up sql query?
What is the basic form of sql query?
What are different functions in sql?
What do you mean by field in sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
When is the explicit cursor used ?
Define overloaded procedure?
what is subquery? : Sql dba
what is the difference between a local and a global temporary table? : Sql dba
What is the maximum rows in csv?
