var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: select ... from (select ...)
is it possible to do a sql order like this
select count(*) from (select * from table)
when I want to do this , I have the message
incorrect syntax near the keyword 'select'
server message number 102 security 15
incorrect syntax near ')'
why ? how to do an order with a subquery in the from clause ?
Last edited by bagache; 09-18-03 at 08:38.
No, you cannot do this except in the very latest version of ASE (12.5.1), which I think is still in beta.