懂數據庫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

👍 0 👎 0