select b.rnum, b.PharmReview_IDX, b.PharmReview_Title, b.PharmReview_Author, b.PharmReview_ViewDate, c.PharmReview_Files_URL from [kdrug_website].[dbo].[PharmReview_Files] c, ( select a.rnum, a.PharmReview_IDX, a.PharmReview_Title, a.PharmReview_Author, a.PharmReview_ViewDate from ( select row_number() over(order by pharmreview_viewdate asc) as rnum,* from kdrug_website.dbo.PharmReview where PharmReview_ViewDate <= convert(varchar(10), getdate(), 23) and PharmReview_Type = '1' ) a where a.rnum between '315' and '324' ) b where b.PharmReview_IDX = c.F_PharmReview_IDX and c.PharmReview_Files_Order = '1' order by b.rnum desc;
의약품검색 바로가기 메뉴바로가기

사용자GNB바

의약품검색

약학정보원

컨텐츠

팜리뷰

  • 학술정보
  • 팜리뷰

팜리뷰

No 제목 저자 게시일 idx
324 복합부위통증증후군(Complex Regional Pain Syndrome: CRPS) (1)김성철2019-04-082793
323 저항성 고혈압곽혜선2019-04-012790
322 손목터널증후군(Carpal tunnel syndrome)김성철2019-03-252786
321 부정맥(2) : 심방세동 환자의 뇌졸중 예방곽혜선2019-03-182782
320 부정맥(1) : 심방세동 환자의 증상조절곽혜선2019-03-112778
319 홍역의 관리 및 치료송영천2019-03-042775
318 심근경색(2)최혁재2019-02-252771
317 심근경색(1)최혁재2019-02-182768
316 급성 기관지염(Acute Bronchitis)최선2019-02-112764
315 간장해독제 - 한약 및 한방제제황완균2019-01-282760