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 : ... 3936 : 3937 : 3938 : 3939 : 3940 : 3941 : 3942 : 3943 : 3944 : ... 6391 : Next »
블로그 이미지

- 홍반장

Archives

Recent Trackbacks

Calendar

«   2024/12   »
일 월 화 수 목 금 토
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 31        
Statistics Graph

Site Stats

Total hits:
253802
Today:
40
Yesterday:
290