테이블에 행번호 만들기
페이지 정보
작성자 서방님 댓글 0건 조회 169회 작성일 06-09-13 11:19본문
This small code helps you to do a query that count all rows, using the statement COUNT. Is very easy and simple, but maybe could be very useful.
SELECT (SELECT COUNT(*) FROM authors e2 WHERE e2.au_id <= e.au_id)
AS rownumber, au_id, au_lname
FROM authors e ORDER BY au_id
자료출처 : http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=5&txtCodeId=821
댓글목록
등록된 댓글이 없습니다.
