Qhov wikiHow qhia koj yuav siv ORDER BY clause hauv SQL los txheeb cov txiaj ntsig los ntawm lub rooj. ORDER BY clause tso cai rau koj txheeb ib lossis ntau kab hauv ob qho kev nce thiab nqis.
Cov kauj ruam
Kauj Ruam 1. Sau SELECT *
Qhov no txhais tau tias peb yuav saib txhua kab ntawv. Tsiv mus rau kab tom ntej.
Kauj ruam 2. Sau FROM table_name
Hloov table_name nrog lub npe ntawm lub rooj, thiab tom qab ntawd txav mus rau kab tom ntej.
Kauj Ruam 3. Sau ORDER BY cov qauv;
Nov yog qee qhov piv txwv:
- Piv txwv li, yog tias koj xav kom pom cov txiaj ntsig hauv cov ntawv xaj raws tus kab ntawv hu ua NAME, koj yuav siv ORDER BY NAME; Kev txiav txim siab nce yog qhov kev txiav txim ua ntej, tab sis koj kuj tseem tuaj yeem hais qhia tias koj xav kom nws nce mus siv ORDER BY NAME ASC; yog koj xav tau
- Yog tias koj xav theej tawm cov txiaj ntsig hauv qhov kev txiav txim rov qab, koj yuav siv ORDER BY NAME DESC; DESC txhais tau tias "kev txiav txim qis."
- Yog tias koj xav txheeb raws li ob kab, cais lawv los ntawm tus lej. Piv txwv li, ORDER BY LAST_NAME ASC, FIRST_NAME DESC; yuav tso tawm cov txiaj ntsig tau txheeb cais los ntawm lub xeem. Yog tib LAST_NAME sib phim ntau FIRST_NAME nkag, cov txiaj ntsig ntawm FIRST_NAME tseem yuav tso tawm kom qis.
Kauj Ruam 4. Ua cov lus txib
Tam sim no koj yuav pom koj cov txiaj ntsig SQL hauv qhov kev txiav txim tsim nyog.