Hi,
I have following table
create table authabs as
(
select 1 empid,100 absmins,'D' type from dual union all
select 1 empid,200 absmins,'P' type from dual union all
select 2 empid,300 absmins,'D' type from dual union all
select 3 empid,400 absmins,'D' type from dual
);
The following query would return two rows.
select * from authabs where empid=1;
But i just want to return single row (top or any of the rows).
I use oracle 10 g
Please help