select count(*) from user order by last_name
"order by" is not necessary. but is it an error according to sql standard?
i accidently wrote the above statement by coping from a previous sql statement which select the records from the the same table.
and interbase let me pass this sql statement. but firebird didn't.
I would like the firebird approach, throw this sql a warning message, to force me write strict sql statement.
but just for the information, is this an error in sql standards?
