armiya
سه شنبه 14 اردیبهشت 1389, 19:47 عصر
با سلام خدمت عزیزان واساتید محترم :می خواستم در مورد ترتیب اجرا و خروجی دستور زیر بدونم که چطور اجرا میشه در query analyzer با تشکر:
select code,date,
(select top 1 t2.date from TVaset as t2 where t2.code > aa.code order by code ) as dd,
(select top 1 t2.code from TVaset as t2 where t2.code > aa.code order by code ) as dc
from TVaset as aa
where (select top 1 ( t2.date < aa.date) from TVaset as t2 where t2.code > aa.code order by code )
order by code
select code,date,
(select top 1 t2.date from TVaset as t2 where t2.code > aa.code order by code ) as dd,
(select top 1 t2.code from TVaset as t2 where t2.code > aa.code order by code ) as dc
from TVaset as aa
where (select top 1 ( t2.date < aa.date) from TVaset as t2 where t2.code > aa.code order by code )
order by code