Hi everybody,

I am facing a problem and I hope that somebody can help me. Here it
is : with SQL server, it is possible to make a request like ' SELECT
TOP(100) FROM TABLE '.
Does it exist the same form of request with SQLBASE ? How to get the
top
(first) lines of a table with one request ?

Thank you for your help

<y.ambroise (AT) yahoo (DOT) fr> wrote

"First"? "Top"? What does that mean (to you)? Does it mean the same thing
to the DBMS? And the end users? Always? Forever?

See if there is a different approach to doing what you want. Fix the table
design if need be.

Roy

<y.ambroise (AT) yahoo (DOT) fr> wrote

"First"? "Top"? What does that mean (to you)? Does it mean the same thing
to the DBMS? And the end users? Always? Forever?

See if there is a different approach to doing what you want. Fix the table
design if need be.

Roy

<y.ambroise (AT) yahoo (DOT) fr> wrote

"First"? "Top"? What does that mean (to you)? Does it mean the same thing
to the DBMS? And the end users? Always? Forever?

See if there is a different approach to doing what you want. Fix the table
design if need be.

Roy

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

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

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

<y.ambroise (AT) yahoo (DOT) fr> wrote


Well this is better. You are now asking the question in a way that is
capable of being answered.

Sadly no. It is a conceit of SQL that it operates on sets (well, more
accurately, bags), and neither sets nor bags admit the concept of order. It
is like asking about colour in the context of Euclidean geometry. So
standard SQL has no way to do what you want. Various SQL dialects add the
ability as a non-standard extension, but there is not even a de facto
standard way to do it.

In the case of the SQL Server dialect, try "select top 10 * from table order
by col", but don't imagine it will be portable to any other dialect you also
want to use.

The only portable solution is one that doesn't call for random subsets of
rows. Unless you are writing a gambling application, try to find a
deterministic solution.

Roy

<y.ambroise (AT) yahoo (DOT) fr> wrote


Well this is better. You are now asking the question in a way that is
capable of being answered.

Sadly no. It is a conceit of SQL that it operates on sets (well, more
accurately, bags), and neither sets nor bags admit the concept of order. It
is like asking about colour in the context of Euclidean geometry. So
standard SQL has no way to do what you want. Various SQL dialects add the
ability as a non-standard extension, but there is not even a de facto
standard way to do it.

In the case of the SQL Server dialect, try "select top 10 * from table order
by col", but don't imagine it will be portable to any other dialect you also
want to use.

The only portable solution is one that doesn't call for random subsets of
rows. Unless you are writing a gambling application, try to find a
deterministic solution.

Roy

<y.ambroise (AT) yahoo (DOT) fr> wrote


Well this is better. You are now asking the question in a way that is
capable of being answered.

Sadly no. It is a conceit of SQL that it operates on sets (well, more
accurately, bags), and neither sets nor bags admit the concept of order. It
is like asking about colour in the context of Euclidean geometry. So
standard SQL has no way to do what you want. Various SQL dialects add the
ability as a non-standard extension, but there is not even a de facto
standard way to do it.

In the case of the SQL Server dialect, try "select top 10 * from table order
by col", but don't imagine it will be portable to any other dialect you also
want to use.

The only portable solution is one that doesn't call for random subsets of
rows. Unless you are writing a gambling application, try to find a
deterministic solution.

Roy