I want to retreive only first record from the specified table
In the Oracle DB some records are there, now i want to retreive only first record from the specified table without using WHERE clause. How to write the query for this?
Re: I want to retreive only first record from the specified table
in agreement with moderator. only with the help of where clause we can restrict the rows how come without using it. still if somehow u get a way out of it do let me know .
all the best
Re: I want to retreive only first record from the specified table
This a for a general employee table but this will not giv right result if the employeeid has a null value...
------------------------------------------------------------------
Select * from employees start
with employee_id=100
connect by prior employee_id is null
-------------------------------------------------------------------
try modifying the code with respect to ur table