Hi Jasajona,

> Are there any way to leave ORDER BY statement without any fields
> listed in it? Something like this:

> SELECT
> *
> FROM
> table1
> ORDER BY
>
> WHERE
> field1 = 100

When you don't want your result set to be sorted you can just leave
away the ORDER BY clause entirely. It's not a must. But when you have
it, it hast to be the last clause, after the WHERE clause.

So your statement would be

SELECT
*
FROM
table1
WHERE
field1 = 100


Regards

Stefan


--
Stefan Heymann
www.destructor.de/firebird