UNION 에서 ORDER BY 절 사용하기

SELECT top 2 title, content ,writeday,id_confer,id_step, id_type FROM (


SELECT top 1 title, content ,writeday,id_confer,id_step, '07' as id_type FROM cm_07 order by writeday desc


union all


SELECT top 1 title, content ,writeday,id_confer,id_step,'08' as id_type FROM cm_08 order by writeday desc )a order by writeday desc
크리에이티브 커먼즈 라이센스
Creative Commons License
이올린에 북마크하기

Posted by 홍반장

2007/06/18 11:28 2007/06/18 11:28
Response
No Trackback , No Comment
RSS :
http://tcbs17.cafe24.com/tc/rss/response/2477

Trackback URL : http://tcbs17.cafe24.com/tc/trackback/2477

« Previous : 1 : ... 90 : 91 : 92 : 93 : 94 : 95 : 96 : 97 : 98 : ... 120 : Next »
블로그 이미지

- 홍반장

Archives

Recent Trackbacks

Calendar

«   2024/11   »
일 월 화 수 목 금 토
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
Statistics Graph

Site Stats

Total hits:
242378
Today:
908
Yesterday:
1266