你知道吗?(在线等)

[zenghaijin]

我在查找数据库时。例如我想输出固定大4个按人数但有时人数相同的很都所以就会输出很多，我应该这样用两个条件来限定呢？谢谢了！
sql3="select Top 3 * from createclass order by membernumber desc and by createtime "
我用上面的为什么不可以呀？

[Struggling]

sql3="select Top 3 * from createclass order by membernumber desc and by createtime desc"

[avonqin]

sql3="select Top 3 * from createclass order by membernumber ，createtime desc"

[smuzy]

基本语法错了

建议你照着sql参考写一下


楼上的对了；

[富察咪咪]

select Top 3 * from createclass order by membernumber desc ,createtime
语法错误 order by 的列之间用“，”分隔

[lyywxl]

sql3="select Top 3 * from createclass order by membernumber ，createtime desc"