Top lines from SQLBASE table

#11

On May 18, 1:23 pm, y.ambro... (AT) yahoo (DOT) fr wrote:

Quote:

Dear Roy,

I am not sure that you caught my problem. The only thing I would like
to know is : To be able to get the top rows from a table even if the
ordering /way of sorting (ORDER BY CLAUSE) is made by DESC or ASC

Can you help me ?

Regards
A.YAO

Use a cursor and stop iterating after the first 100 fetches. There is
no standard way in SQL to define the "TOP(100)".

Ed

#12

On May 18, 1:23 pm, y.ambro... (AT) yahoo (DOT) fr wrote:

Quote:

Dear Roy,

I am not sure that you caught my problem. The only thing I would like
to know is : To be able to get the top rows from a table even if the
ordering /way of sorting (ORDER BY CLAUSE) is made by DESC or ASC

Can you help me ?

Regards
A.YAO

Use a cursor and stop iterating after the first 100 fetches. There is
no standard way in SQL to define the "TOP(100)".

Ed

#13

On May 18, 1:23 pm, y.ambro... (AT) yahoo (DOT) fr wrote:

Quote:

Dear Roy,

I am not sure that you caught my problem. The only thing I would like
to know is : To be able to get the top rows from a table even if the
ordering /way of sorting (ORDER BY CLAUSE) is made by DESC or ASC

Can you help me ?

Regards
A.YAO

Use a cursor and stop iterating after the first 100 fetches. There is
no standard way in SQL to define the "TOP(100)".

Ed

#14

"Ed Prochak" <edprochak (AT) gmail (DOT) com> wrote

Quote:

On May 18, 1:23 pm, y.ambro... (AT) yahoo (DOT) fr wrote:
Dear Roy,

I am not sure that you caught my problem. The only thing I would like
to know is : To be able to get the top rows from a table even if the
ordering /way of sorting (ORDER BY CLAUSE) is made by DESC or ASC

Can you help me ?

Regards
A.YAO

Use a cursor and stop iterating after the first 100 fetches. There is
no standard way in SQL to define the "TOP(100)".

One day I will post a funny story here, about how I lost my job after
top-slicing a table and supplying a minister with partial data in response
to a written question in parliament.

Roy

#15

"Ed Prochak" <edprochak (AT) gmail (DOT) com> wrote

Quote:

On May 18, 1:23 pm, y.ambro... (AT) yahoo (DOT) fr wrote:
Dear Roy,

I am not sure that you caught my problem. The only thing I would like
to know is : To be able to get the top rows from a table even if the
ordering /way of sorting (ORDER BY CLAUSE) is made by DESC or ASC

Can you help me ?

Regards
A.YAO

Use a cursor and stop iterating after the first 100 fetches. There is
no standard way in SQL to define the "TOP(100)".

One day I will post a funny story here, about how I lost my job after
top-slicing a table and supplying a minister with partial data in response
to a written question in parliament.

Roy

#16

"Ed Prochak" <edprochak (AT) gmail (DOT) com> wrote

Quote:

On May 18, 1:23 pm, y.ambro... (AT) yahoo (DOT) fr wrote:
Dear Roy,

I am not sure that you caught my problem. The only thing I would like
to know is : To be able to get the top rows from a table even if the
ordering /way of sorting (ORDER BY CLAUSE) is made by DESC or ASC

Can you help me ?

Regards
A.YAO

Use a cursor and stop iterating after the first 100 fetches. There is
no standard way in SQL to define the "TOP(100)".

One day I will post a funny story here, about how I lost my job after
top-slicing a table and supplying a minister with partial data in response
to a written question in parliament.

Roy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Top lines from SQLBASE table

comp.databases comp.databases

Re: Top lines from SQLBASE table - 05-19-2008 , 06:41 AM

Re: Top lines from SQLBASE table - 05-19-2008 , 06:41 AM

Re: Top lines from SQLBASE table - 05-19-2008 , 06:41 AM

Re: Top lines from SQLBASE table - 05-19-2008 , 07:19 AM

Re: Top lines from SQLBASE table - 05-19-2008 , 07:19 AM

Re: Top lines from SQLBASE table - 05-19-2008 , 07:19 AM