如何同时按两个字段来排序,语句如下:SELECT YY,TYPE,MM FROM B_CLDRF
WHERE YY = '2006' AND MM = '3'
ORDER BY YY
AND ORDER BY MM ------------------>有误请问要如何写这种语句?先谢过
WHERE YY = '2006' AND MM = '3'
ORDER BY YY
AND ORDER BY MM ------------------>有误请问要如何写这种语句?先谢过
WHERE YY = '2006' AND MM = '3'
ORDER BY YY, MM
from b_cldrf
where yy='2006' and mm='3'
order by yy,mm
WHERE YY = '2006' AND MM = '3'
ORDER BY YY,MM
WHERE YY = '2006' AND MM = '3'
ORDER BY YY,MM
from b_cldrf
where yy='2006' and mm='3'
order by yy,mm