okiwan/gist:6256f86699f325e58576

Created March 23, 2016 16:24

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

Select an option

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

Download ZIP

Raw

gistfile1.txt

select to_timestamp(t.timestamp), u.first_name, u.last_name, t.destination, t.pol_start, t.pol_end, t.status from registered_user u, transaction t where u.id = t.user_id order by t.timestamp desc limit 20;

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