SQL语句如下:
SELECT top 10 * FROM Ds_ConvertTable as myJBGD /////下面的是一个有序的结果集
inner join (SELECT TSL.* FROM Ds_ConvertTable AS TSL INNER JOIN CONTAINSTABLE(Ds_ConvertTable,appeal_content,'ISABOUT (桃花 NEAR 苑,桃花,苑 )',999999)AS KEY_TBL ON TSL.ID = KEY_TBL.[KEY]) as myFenCi on myFenCi.GD_ID=myJBGD.GD_ID where myJBGD.sl_time>='2004-03-11' and myJBGD.sl_time<='2007-4-28' 我想执行这个SQL语句,中间标出来的是有序的结果集,外面的是无序的,我想按里面的排序,请问如果做?我用了内连接,可是结果是无序的,我也试了右连接和左连接,都不是我想要的结果,请问如何做才能实现最后的结果按我标出的部分顺序进行列出来??
SELECT top 10 * FROM Ds_ConvertTable as myJBGD /////下面的是一个有序的结果集
inner join (SELECT TSL.* FROM Ds_ConvertTable AS TSL INNER JOIN CONTAINSTABLE(Ds_ConvertTable,appeal_content,'ISABOUT (桃花 NEAR 苑,桃花,苑 )',999999)AS KEY_TBL ON TSL.ID = KEY_TBL.[KEY]) as myFenCi on myFenCi.GD_ID=myJBGD.GD_ID where myJBGD.sl_time>='2004-03-11' and myJBGD.sl_time<='2007-4-28' 我想执行这个SQL语句,中间标出来的是有序的结果集,外面的是无序的,我想按里面的排序,请问如果做?我用了内连接,可是结果是无序的,我也试了右连接和左连接,都不是我想要的结果,请问如何做才能实现最后的结果按我标出的部分顺序进行列出来??
inner join (SELECT TSL.* FROM Ds_ConvertTable AS TSL INNER JOIN CONTAINSTABLE(Ds_ConvertTable,appeal_content,'ISABOUT (桃花 NEAR 苑,桃花,苑 )',999999)AS KEY_TBL ON TSL.ID = KEY_TBL.[KEY])as myFenCion myFenCi.GD_ID=myJBGD.GD_ID where myJBGD.sl_time>='2004-03-11' and myJBGD.sl_time<='2007-4-28'
oder by 要排序的字段1 asc/desc,要排序的字段2 desc/asc--以上是示意
把它的信息也select出来
再在整个语句后面写 ORDER BY A