This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Nice article @Mintz ! How about this on below ? i have done try to
remove order by but still cant running, what does the ideal query ?
SELECT id as data, RANK() OVER (ORDER BY date_update) AS rank
FROMtest.sampleORDER BY id DESC LIMIT 1