INSERT INTO test_view VALUES(1,'DDDD')
INSERT INTO test_view VALUES(2,'CCCC')
INSERT INTO test_view VALUES(3,'BBBB')
INSERT INTO test_view VALUES(4,'AAAA')
SELECT * FROM test_view
CREATE VIEW view1
AS
SELECT c2 FROM test_view
ORDER BY c2
SELECT * FROM view1
SELECT * FROM view1 ORDER BY c2 DESC
CREATE VIEW view2
AS
SELECT * FROM test_view
SELECT * FROM view2
SELECT * FROM view2 ORDER BY c1 DESC
-------------------------------------------------------------
可通过以下链接下载免费的SQL Anywhere Studio 9 开发版
http://ap.sybase.com/gvswse/site/china/sdn/iAnywhereDevDownIndex.jsp