silasrm/new_gist_file

Created September 14, 2013 00:28

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/silasrm/6557693.js"></script>
Save silasrm/6557693 to your computer and use it in GitHub Desktop.

Download ZIP

From http://sqlfiddle.com/#!2/9635d2/1

Raw

new_gist_file

SELECT col1, col2, @pv:=col3 AS 'col3' FROM table1 JOIN (SELECT @pv:=1)tmp WHERE col1=@pv

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