The correct query uses count(distinct):
select actionID, count(distinct userId) as howManyUsers
from table
group by actionID
42 (forty-two) is the natural number immediately following 41 and directly preceding 43. The number has received considerable attention in popular culture as a result of its central appearance in The Hitchhiker's Guide to the Galaxy as the "Answer to the Ultimate Question of Life, the Universe, and Everything".
Mathematics
* Forty-two is a pronic number and an abundant number; its prime factorization 2 · 3 · 7 makes it the second sphenic number and also the second of the form { 2 · 3 · r }. As with all sphenic numbers of this form, the...
You will want to include the wildcard % character to include the rows the have George present in the name:
SELECT *
FROM customers
WHERE Firstname LIKE '%George%';
If George will always appear at the beginning, then you can include the wildcard on the end:
SELECT *
FROM customers
WHERE Fir...
Each employee is given an opportunity to record date of visit up to 3 visits.
How do I determine employee's most current date of visit and add 3 years to it?
I tried the following:
select top 1 dateOfVisit from table
where empid=123
Order by dateOfVisit DESC
This isn't giving me most ...
