Posts Tagged ‘count’

Counting the number of occurrences of a given character in a std::string can be done using one function from the STL library: the std::count(…) function. This function takes three parameters: two iterators (the beginning and end of the desired search), and the item you wish to count. This function can be used for any STL […]

Conditional COUNT in SQL

Posted: 10th October 2010 by Tim in SQL
Tags: , , , , , , , , , , ,

Sometimes you want to count the number of results which meet a certain condition. Excel has a COUNTIF(…) function but there is nothing like that in the (current) SQL standard. The solution is to mix the SUM function with a CASE statement. Confused? Let’s see an example. Imagine you have two tables – student (student_id, […]

Standard LaTeX allows you to extract the current page number using the thepage command. That’s an easy one. To get the total number of pages (ie: number of the last page) is a little more involved. To do this, you need to use the \lastpage package and use \pageref{LastPage}. For example: \usepackage{lastpage} … You are […]