34,588
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
yxin 2002-01-23
- 打赏
- 举报
明白了，给分了
supsuccess 2002-01-23
- 打赏
- 举报
select count(*) as count from tablename ====>表中所有记录个数
select count(ColName) as count from tablename ====>表中所有ColName列不为空的记录个数
select count(ColName) as count from tablename ====>表中所有ColName列不为空的记录个数
net_steven 2002-01-23
- 打赏
- 举报
select count(*) from yourtable
warning 2002-01-23
- 打赏
- 举报
总数？
select count(*) from tablename
select count(*) from tablename
huyuefox 2002-01-23
- 打赏
- 举报
oracle:
select count(*) count from tablename;
COUNT
---------
3
select count(*) count from tablename;
COUNT
---------
3
