아

union top n 가져오기

select top 8 -- 상위 8개만 가져올때 사용합니다.

b_index, b_subject, b_date, b_xgg, b_xd

from (

select b_index, b_subject, b_date, b_xgg, b_xd from a where b_xgg='1'

union all

select b_index, b_subject, b_date, b_xgg, b_xd from b where b_xgg='1'

union all

select b_index, b_subject, b_date, b_xgg, b_xd from c where b_xgg='1'

union all

select b_index, b_subject, b_date, b_xgg, b_xd from d where b_xgg='1'

) a

order by b_index desc<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]</div>

댓글 1개

top 8은 M$SQL에서 가능합니다.
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
06-08-18 조회 2,935
06-08-18 조회 3,036
06-08-14 조회 2,472
06-08-13 조회 2,765
06-08-12 조회 3,902
06-08-12 조회 3,031
06-08-11 조회 4,250
06-08-11 조회 4,198
06-08-10 조회 3,294
06-08-10 조회 2,871
06-08-09 조회 3,919
06-08-08 조회 3,927
06-08-08 조회 5,179
06-08-08 조회 3,046
06-08-07 조회 3,783
06-08-06 조회 3,415
06-08-06 조회 4,542
06-08-05 조회 2,494
06-08-05 조회 2,562
06-08-05 조회 2,850
06-08-05 조회 3,323
06-08-05 조회 2,876
06-08-05 조회 2,803
06-08-04 조회 3,186
06-08-04 조회 3,325
06-08-04 조회 6,023
06-08-04 조회 3,421
06-08-04 조회 4,280
06-08-04 조회 3,723
06-08-03 조회 3,508
06-08-01 조회 5,776
06-07-31 조회 3,625
06-07-31 조회 3,459
06-07-30 조회 3,004
06-07-30 조회 2,783
06-07-29 조회 4,473
06-07-29 조회 3,427
06-07-28 조회 7,252
06-07-27 조회 3,184
06-07-26 조회 2,934
06-07-26 조회 3,807
06-07-26 조회 2,856
06-07-26 조회 3,346
06-07-25 조회 3,221
06-07-25 조회 4,651
06-07-25 조회 3,611
06-07-25 조회 3,818
06-07-24 조회 5,476
06-07-24 조회 4,714
06-07-23 조회 3,411
06-07-23 조회 5,496
06-07-22 조회 4,444
06-07-21 조회 5,262
06-07-21 조회 3,093
06-07-21 조회 3,290
06-07-21 조회 3,252
06-07-20 조회 4,406
06-07-20 조회 3,814
06-07-20 조회 4,566
06-07-20 조회 3,784
06-07-20 조회 3,615
06-07-20 조회 3,471
06-07-20 조회 3,306
06-07-20 조회 3,235
06-07-20 조회 5,374
06-07-20 조회 3,773
06-07-20 조회 3,297
06-07-20 조회 3,336
06-07-20 조회 3,965
06-07-19 조회 3,046
06-07-19 조회 4,382
06-07-19 조회 3,927
06-07-19 조회 3,386
06-07-19 조회 2,880
06-07-19 조회 3,308
06-07-19 조회 3,157
06-07-19 조회 3,000
06-07-19 조회 3,553
06-07-19 조회 3,400
06-07-19 조회 4,978
06-07-19 조회 4,842
06-07-19 조회 3,356
06-07-19 조회 4,383
06-07-19 조회 3,082
06-07-19 조회 3,512
06-07-19 조회 3,429
06-07-17 조회 3,434
06-07-17 조회 3,271
06-07-16 조회 3,865
06-07-14 조회 3,916
06-07-14 조회 4,319
06-07-14 조회 4,192
06-07-14 조회 3,798
06-07-13 조회 4,085
06-07-13 조회 4,264
06-07-12 조회 4,011
06-07-11 조회 3,715
06-07-11 조회 4,000
06-07-11 조회 5,639
06-07-11 조회 3,549