Skip to content

Instantly share code, notes, and snippets.

@nakamura-to

nakamura-to/dynamic-order-by.sql

Created April 4, 2015 00:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nakamura-to/47e0f1a58d236d8fac8b to your computer and use it in GitHub Desktop.
Save nakamura-to/47e0f1a58d236d8fac8b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dynamic-order-by.sql
select
age, name, birthday
from
person
order by
/*%if mode == 1 */
　age, name
/*%elseif mode == 2 */
/*# "name, age" */
/*%else */
/*# "birthday" */
/*%end　*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment