Question

昨天我想制造一个小盘(使用系统,数据.sqlce),从移动装置的分散表格中收回价值。

My scenario is as follows: - sql table: Xtable (fields: name : is string, mat : is string, state : is int value); - XTable contains 100 records my sql statement is:

SELECT name, (SELECT count(*) from Xtable where state=0) as Marked, count(*) as Total
FROM XTable
GROUP BY name

结果是:0行,因为一行与第二次选举考试有误。

国际联合会我在发言时说:

SELECT name, count(*) as Total FROM XTable GROUP BY name
result : > 0 rows.

Sqlcecommand not support multiselect query? how can I fix it ?

Answer 1

页: 1 契约不支持这种排序。 See ,thisMSDN Forum thread for accreditation。

Answer 2

如果你能够提供错误细节,就很容易帮助你。

(SELECT count() from Xtable where state=0)

(a) 没有任何理由

(SELECT count(*) from Xtable where state=0)

<><>Edit>/strong>

您的编辑***** 作为论点,见count。最初没有,这是正确的。

友情链接