Hi!

Unfortunately, NO. Different databases use different rules for ORDER BY and tables naming. For example, some backends allow only double quotes around names that match keywords or are not standard. Some backends do not allow use of numbers in ORDER BY.


>Thanks, Sergey, Mike and Cindy. That's actually a question in the test. It doesn't specify a back-end. Would the same SQL be other databases (Access, VFP - obviously, it would, Oracle, etc.) complaint?
>
>Also sorry for unrelated question, but could you please give me a good link for UML (introduction)?
>
>>Hi Nadya,
>>
>>If table/filed name doesn't follow requiremebnts for MS SQL indetifiers, you can enclose them into square brackets. If you want to be the SQL-92 compliant, you can use double quotes but it requires SET QUOTED_IDENTIFIER to be set to ON at parse time.
>>Using column names or column #'s, is a matter of personal preference. I usually use column names so I can freely rearange columns in the list if I have to.
>>
>>>Hi everyone,
>>>
>>>Sorry for such novice question, but it got me stumped for a moment. How can I use ORDER BY clause for ORDER table? Also what is better: name every field like select company, OrderNumber from [ORDER] order by company, OrderNumber or select company, OrderNumber from [ORDER] order by 1,2 ?
>>>
>>>Thanks in advance.