It generates this error:
Warning: mssql_query(): message: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS
Obviously I did try it in all formats possible
I have found this workaround:
select * from (
select top 20 index from (
select top 10 index from table_blah order by index asc
) as newtbl order by index desc
) as newtbl2 order by index asc
This works, but it’s still not as effective as LIMIT
An avid fan of business, education, technology and finance. I lead a lean, highly focussed and capable team of Java Back End developers and Front End developers through a maze of complex software wizardry to fulfill the web maintenance needs of a large chemical manufacturer. As per Myers-Briggs Personality Types, I am an ESTJ. I pride in a project completed on time and according to plan. My hobbies include all kinds of technology, anything that I can taste and anything that goes fast or flies in the air. I like to read business books and comics in my spare time.
It generates this error:
Warning: mssql_query(): message: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS
Obviously I did try it in all formats possible
I have found this workaround:
select * from (
select top 20 index from (
select top 10 index from table_blah order by index asc
) as newtbl order by index desc
) as newtbl2 order by index asc
This works, but it’s still not as effective as LIMIT