Re: Next and Previos Row in the Table

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Wed, 12 Jun 2002 09:32:56 +0600
Message-ID: <ae6fd3$4cg0c$1@ID-127142.news.dfncis.de>

Sorry,
the right query...

select * from emp_table
where EMPLOYEE_ID in (
888,
(select min(EMPLOYEE_ID) from emp_table where EMPLOYEE_ID>888), (select max(EMPLOYEE_ID) from emp_table where EMPLOYEE_ID<888) )

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com

"Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message
news:ae3p00$3fon5$1_at_ID-127142.news.dfncis.de...


> Hi,

>

> select * from emp_table

> where EMPLOYEE_ID in (

>   888,

>   (select min(EMPLOYEE_ID) from a where EMPLOYEE_ID>888),

>   (select max(EMPLOYEE_ID) from a where EMPLOYEE_ID<888)

> )

>

> Regards,

> --

> Roman Mirzaitov

> Brainbench MVP for Oracle Administration

> www.brainbench.com

>

>

> "Munda" <munda_73_at_yahoo.com> wrote in message

> news:c2b0e26b.0206101233.67d75be5_at_posting.google.com...

> > I have a employee table as following

> > EMPLOYEE_ID Number

> > EMPLOYEE_NAME VARCHAR2(20)

> >

> > For example consider table has following data

> >

> > EMPLOYEE_ID EMPLOYEE_NAME

> > 111 a

> > 333 c

> > 555 e

> > 666 f

> > 888 h

> > 999 i

> >

> >

> > I want to display Previous and Next record for the specific Employee .

> > For Example

> > If I the specified employee id is 888 then I will need employee 666 and

> 999

> > I want these in single SQL .

> > Please email me back @ munda_73_at_yahoo.com

> > Help will be greatly appreciated

>

>

>

>

Received on Tue Jun 11 2002 - 22:32:56 CDT