{"id":3379,"date":"2016-07-22T08:56:22","date_gmt":"2016-07-22T08:56:22","guid":{"rendered":"https:\/\/kiencang.net\/?p=3379"},"modified":"2016-07-22T08:56:22","modified_gmt":"2016-07-22T08:56:22","slug":"tu-khoa-order-by-trong-sql","status":"publish","type":"post","link":"https:\/\/kiencang.net\/tu-khoa-order-by-trong-sql\/","title":{"rendered":"T\u1eeb kho\u00e1 ORDER BY trong SQL"},"content":{"rendered":"\n

T\u1eeb kho\u00e1 ORDER BY<\/code> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 s\u1eafp x\u1ebfp kh\u1ed1i k\u1ebft qu\u1ea3 b\u1edfi m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t.<\/p>\n\n\n\n

T\u1eeb kho\u00e1 ORDER BY<\/code> s\u1eafp x\u1ebfp c\u00e1c b\u1ea3n ghi theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n theo m\u1eb7c \u0111\u1ecbnh. \u0110\u1ec3 s\u1eafp x\u1ebfp c\u00e1c b\u1ea3n ghi theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 DESC<\/code>.<\/p>\n\n\n\n

C\u00fa ph\u00e1p c\u1ee7a ORDER BY<\/code> trong SQL:<\/h3>\n\n\n\n
SELECT ten_cot, ten_cot\nFROM ten_bang\nORDER BY ten_cot ASC|DESC, ten_cot ASC|DESC;<\/code><\/pre>\n\n\n\n
\n\n\n\n
\n
\n

M\u1ee5c l\u1ee5c<\/p>\n