douglascabral/mysql-rownumber.sql

Created July 20, 2016 13:44

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/douglascabral/9b001b74fd356822b2fe4319b5d39e26.js"></script>
Save douglascabral/9b001b74fd356822b2fe4319b5d39e26 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

mysql-rownumber.sql

	SELECT
	@rownum := @rownum + 1 AS rownumber
	FROM
	(SELECT @rownum := 0) AS tbl_rownumber

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment