有关于SQL Serve编程语言，😊

Question

求各位大佬看看，这应该怎么做呀😊😊😊

🤔

Answer 1

1.select * from T_Computer
2.select top 1 from T_Computer order by computerprice desc
3.insert into T_Computer (computername,computerprice) values('小米',3990)
4.update t_computer set computerprice=7199 where computername='ThinkPad'
5.select * from t_computer where computerid in(select top 2 id from t_order by count(id) desc group by id)

Answer 2

感谢，感谢😊

Answer 3

第5题应该是sum（num），不是count(id)

Answer 4

好