MangoLiu/tableRows

Created October 8, 2014 08:38

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/MangoLiu/92b4dd13fc8b89347bdf.js"></script>
Save MangoLiu/92b4dd13fc8b89347bdf to your computer and use it in GitHub Desktop.

Download ZIP

获取数据表的行数

Raw

	select count(*)
	from 表名
	where 条件

Author

MangoLiu commented Oct 8, 2014

--根据某列去重
select count(DISTINCT 列名)
from 表名
where 条件

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment