??如何统计数据表中满足某条件的记录个数??送lOO分哦!!
(1)CADORecordset m_Rs (ADO方式访问数据库)
(2)数据表stu及"score"字段
(3)打开stu表
m_Rs.Open("SELECT * FROM stu");
(4)统计stu中满足"score>60"的记录个数,代码怎样写?VC下怎样用代码访问这个统计值?
ps: msdn给出如下sql语句格式,但vc下该如何使用?
SELECT Count(Amount) AS [Number of Valid Invoice Amounts] FROM tblInvoices