Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

rownum in sql

SELECT ROWNUM, a.*
FROM (SELECT customers.*
      FROM customers
      WHERE customer_id > 4500
      ORDER BY last_name) a;
Source by www.techonthenet.com #
 
PREVIOUS NEXT
Tagged: #rownum #sql
ADD COMMENT
Topic
Name
5+3 =