你好朋友帮我吗? [英] hello Friend's Help ME?

问题描述

我有一张桌子.

CID CNAME CPOINT

1个400

2羽300

3 c 200

4 d 100

5 e 200

6 f 300



现在如何根据此表中的前3个CPOINT选择数据.

前3个均值-对于所有Vale为400，所有值为300和所有值为200

PLZ HELP ME.

I Have a Table For Example.

CID CNAME CPOINT

1 a 400

2 b 300

3 c 200

4 d 100

5 e 200

6 f 300



Now how to select data according to top 3 CPOINT From This Table.

Top 3 Means - for all Vale of 400 and for all value of 300 and for all value of 200

PLZ HELP ME.

推荐答案

Select top 3 from myTable where cpoint>200.

这篇关于你好朋友帮我吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！