{"id":3397,"date":"2016-07-25T08:44:09","date_gmt":"2016-07-25T08:44:09","guid":{"rendered":"https:\/\/kiencang.net\/?p=3397"},"modified":"2016-07-25T08:44:09","modified_gmt":"2016-07-25T08:44:09","slug":"menh-de-sql-select-top","status":"publish","type":"post","link":"https:\/\/kiencang.net\/menh-de-sql-select-top\/","title":{"rendered":"M\u1ec7nh \u0111\u1ec1 SQL SELECT TOP"},"content":{"rendered":"\n

M\u1ec7nh \u0111\u1ec1 SELECT TOP<\/code> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh s\u1ed1 b\u1ea3n ghi tr\u1ea3 v\u1ec1.<\/p>\n\n\n\n

M\u1ec7nh \u0111\u1ec1 SELECT TOP<\/code> c\u00f3 th\u1ec3 r\u1ea5t h\u1eefu d\u1ee5ng cho c\u00e1c b\u1ea3ng ghi l\u1edbn v\u1edbi h\u00e0ng ng\u00e0n b\u1ea3n ghi. Tr\u1ea3 v\u1ec1 m\u1ed9t l\u01b0\u1ee3ng l\u1edbn b\u1ea3n ghi c\u00f3 th\u1ec3 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u su\u1ea5t, t\u1ed1c \u0111\u1ed9 hi\u1ec3n th\u1ecb trang.<\/p>\n\n\n\n

L\u01b0u \u00fd: T\u1ea5t c\u1ea3 h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u hi\u1ec7n \u0111\u1ec1u h\u1ed7 tr\u1ee3 m\u1ec7nh \u0111\u1ec1 SELECT TOP<\/code>.<\/p>\n\n\n\n

C\u00fa ph\u00e1p SQL Server \/ MS Access:<\/p>\n\n\n\n

SELECT TOP number|percentcolumn_name(s)\nFROM table_name;<\/code><\/pre>\n\n\n\n
\n\n\n\n
\n
\n

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