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 Comments

  1. 1 pHqghUme 01/05
  2. 1 pHqghUme 01/05
  3. 1 pHqghUme 01/05
  4. 1 pHqghUme 01/05
  5. 1 pHqghUme 01/05

Calendar

«   2025/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:
330815
Today:
87
Yesterday:
244