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

사용자GNB바

의약품검색

약학정보원

컨텐츠

팜리뷰

  • 학술정보
  • 팜리뷰

팜리뷰

No 제목 저자 게시일 idx
284 영양소 섭취량오성곤2018-06-182666
283 무좀과 복약지도김성철2018-06-111663
282 식물요법(Phytotherapy) - 폐경황완균2018-06-041661
281 폐경 증상 완화를 위한 치료제정경혜2018-05-281659
280 Biological product-biosimilars최선2018-05-211657
279 약물사용에 대한 최신지견 : A형 간염곽혜선2018-05-141655
278 류마티스 관절염의 약물요법송영천2018-04-301652
277 반사회적 인격장애(3)최혁재2018-04-231649
276 반사회적 인격장애(2)최혁재2018-04-161645
275 반사회적 인격장애(1)최혁재2018-04-091643