java, c# , linux, program devloper

blog.visualp.com

Blog
  • Cover
  • Notice
  • Guest Book
  • Tag &
    • Tag List
    • Location
    • Keywords
    • Lines
  • Control Panel
  • Write a Post

오라클에서 MySql 의 Limit 구현

Posted 2012/04/24 14:38
Filed under ORACLE
[원문] http://depository.tistory.com/entry/%EC%98%A4%EB%9D%BC%ED%81%B4%EC%97%90%EC%84%9C-MySql-%EC%9D%98-Limit-%EA%B5%AC%ED%98%84
테이블에서 최신 레코드만 가지고 오고 싶을때

MySql
select * from tableA order by reg_dt desc limit 1;


Oracle
select * (select * from tableA order by reg_dt desc) where rownum = 1;
2012/04/24 14:38 2012/04/24 14:38
Posted by java, tomcat, c#
RSS 2.0 feed
ATOM 1.0 feed
Response
You can track responses via RSS / ATOM feed
RSS 2.0 feed
ATOM 1.0 feed
  • Trackbacks0
  • Comments0
Trackback URL
이 글에는 트랙백을 보낼 수 없습니다
Trackback ATOM Feed
http://blog1.phps.kr/atom/trackback/471
  • 1
  • ...
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • ...
  • 734
namecard image

blog.visualp.com

by java, tomcat, c#

  1. Calendar

  2. «   2023/06   »
    일 월 화 수 목 금 토
            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  
  1. Tag Cloud

    • global play
    • replace
    • 포프리계란
    • actionscript3.0 trim
    • Object Serialization
    • timer
    • php ajax 처리
    • #바른손카드
    • 윈도우서비스등록
    • org.apache.struts.util.LabelValueBean
    • export
    • 직열화
    • 김창옥
    • iterate
    • 국가코드
    • ico conver
    • onload
    • window.close
    • select
    • png24 배경 으로 사용하려면
    • drag and drop
    • 실제주소
    • find method
    • ac3.0 drag
    • mdf
    • jquery 로딩 완료시점
    • 리눅스 하드 추가
    • asp.net web service
    • modjk
    • jsp directory
  1. Notices

  1. Archives

  2. 2020/08 (1)
  3. 2020/04 (2)
  4. 2019/11 (1)
  5. 2019/08 (1)
  6. 2019/07 (1)
  1. Categories

    • ATOM 전체 734
      • ATOM 포프리쇼(fourfreeshow) 34
      • ATOM C# 50
      • ATOM PHP 57
      • ATOM JSP, JAVA 103
      • ATOM spring framework 6
      • ATOM Htm&Javascript 79
      • ATOM Scorm 26
      • ATOM 웹표준 12
      • ATOM Action Script 59
      • ATOM music 4
      • ATOM etc 36
      • ATOM Link 8
      • ATOM Linux 90
      • ATOM nginx 4
      • ATOM centos7 8
      • ATOM Mysql 32
      • ATOM ORACLE 22
      • ATOM C,C++ 7
      • ATOM asp,asp.net 27
      • ATOM android 5
      • ATOM jquery 11
      • ATOM iphone 34
      • ATOM portfolio 0
        • ATOM web 0
        • ATOM mobile 0
        • ATOM application 0

java, c# , linux, program devloper - 최근 글

  1. Recent Posts

  2. intelij svn 느림 by java, tomcat, c#
  3. c# cefsharp filedownload 구현 by java, tomcat, c#
  4. tomcat8 cookie 관련 by java, tomcat, c#
  5. php error 출력 by java, tomcat, c#
  6. required attribute scrolli... by java, tomcat, c#
  1. Recent Comments

  2. java, c# , linux, program devloper - 최근 댓글

  1. Recent Trackbacks

  2. java, c# , linux, program devloper - 최근 트랙백

  1. Authors

  2. java, tomcat, c#
  1. Bookmarks

  1. Site Stats

  2. Total hits
    5798283
    Today
    632
    Yesterday
    2869
  1. Textcube
  1. Feeds

  2. Subscribe to RSS articles
  3. Subscribe to RSS responses
  4. Subscribe to ATOM articles
  5. Subscribe to ATOM responses
java, tomcat, c#'s site.
java, c# , linux, program devloper
Powered by Textcube 1.10.7 : Tempo primo, Persona skin designed by inureyes edited by LonnieNa