3 ms·
in PG (such as using an ORDER BY) You can use order by in a CTE in mssql, you just have to specify a TOP clause. ;with bar as ( select top 100 percent *
by dsp1234 10y ago
in PG (such as using an ORDER BY)
You can use order by in a CTE in mssql, you just have to specify a TOP clause.
;with bar as (
select top 100 percent *
from foo
order by foo.name
)
select *
from bar
- netcraft 10y agointeresting, im pretty certain I couldnt do this with the version I was using at the time, but maybe I just didnt have the right google fu - I wonder what version that came with?