问题没说清楚啊,你这个key指的是表的主键还是说你表中有一列,列名就叫key呢.如果你的列名就叫key,那么按照595456225给的方法不会出现什么等于0的值啊.除非你表的空的没数据.另外什么叫＂前一位是A的结果＂?没明白你的问题.
select count(*) as total from ddcm_news where key=a
1个回答
相关问题
-
dim cm as New SqlCommand("select count(*) from Users where u
-
SQL语句理解 select * from B where (select count(1) as num from A
-
$sql="SELECT count(*) as pcount FROM news" 和$sql = "UPDATE a
-
ms sql :select * from (select *from b) as xxx where 和 select
-
如何提高下面语句的效率select * from(select a_month ,b_name ,count(DISTI
-
delete from A where a_id in (select id from B where b_id in
-
select count(*)count 什么意思和select * 有什么区别
-
SELECT MAX(account) AS account FROM shop 和 SELECT MAX(accoun
-
奇怪的事情发生了.关于查询语法rs.open "select Top 24 * from news where BigC
-
select * from v$locked_object a,user_objects b where a.OBJEC