这是sql语句:
select count(1) from (select count(*) as counts from t_faultdata where fd_sign=1 group by fd_event_code,fd_event_desc)t
在sql developer中执行这条语句时显示是
COUNT(1)
1 96
但用.NET中的ExecuteScalar()方法查出来的却是5
object obj = myORACCommand.ExecuteScalar();
Response.Write("show:" + obj);
这到底是怎么回事,真是百思不得其解,求大神们支招