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 '285' and '294' ) b where b.PharmReview_IDX = c.F_PharmReview_IDX and c.PharmReview_Files_Order = '1' order by b.rnum desc;
의약품검색 바로가기 메뉴바로가기

사용자GNB바

의약품검색

약학정보원

컨텐츠

팜리뷰

  • 학술정보
  • 팜리뷰

팜리뷰

No 제목 저자 게시일 idx
294 중이염의 합리적 접근법김성철2018-08-272692
293 대사증후군과 전립선비대증송영천2018-08-202688
292 월경전 증후군주경미2018-08-132686
291 장티푸스(2)최혁재2018-08-062683
290 장티푸스(1)최혁재2018-07-302682
289 헤르페스(2)최혁재2018-07-232679
288 헤르페스(1)최혁재2018-07-162676
287 선블록과 백화현상황완균2018-07-092673
286 경구용 항응고제 II: DOAC곽혜선2018-07-022669
285 경구용 항응고제 I: Warfarin곽혜선2018-06-252668