懂數據庫Oracle(SQL)請幫忙

2008-10-29 11:39 pm
Create an index on LastName in descending order in the table Author.

我只係識咁打…
CREATE INDEX DescendingLN_Ind ON Author(LastName);

但係就唔識點整成降序…
請幫忙 T.T

回答 (1)

2008-10-31 1:54 am
✔ 最佳答案
CREATE INDEX DescendingLN_Ind ON Author(LastName DESC);

ASC for ascending order


收錄日期: 2021-04-25 20:34:52
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20081029000051KK00555

檢視 Wayback Machine 備份