select * into bbb
from (select yearly_income,gender,education,num_cars_owned from( select top 100 * from customer_1998 order by newid()) a order by total_money desc)
from (select yearly_income,gender,education,num_cars_owned from( select top 100 * from customer_1998 order by newid()) a order by total_money desc)
“除非同时指定了 TOP,否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。“
from (select top 100 percent yearly_income,gender,education,num_cars_owned from( select top 100 percent * from customer_1998 order by newid()) a order by total_money desc)
------top 100 percent
“第 2 行: ')' 附近有语法错误。”