SQL Query to find unique count

Question

Here's a little bit of background. I have a database like this:

    uristem       username
  +------------+  +-------+
  | /uristem/1 |  | user1 |
  | /uristem/2 |  | user2 |
  | /uristem/3 |  | user3 |
  | /uristem/3 |  | user4 |
  | /uristem/1 |  | user1 |
  | /uristem/7 |  | user5 |
  | /uristem/5 |  | user3 |
  | /uristem/5 |  | user1 |
  | /uristem/3 |  | user1 |
  +------------+  +-------+

I need to count the number of (unique) users that hit /uristem/3. What operators can I use in a query to do this?

Your help is greatly appreciated,

Thanks!

Thank you for the response! I'm not skilled in this area and know very little, so it helps a lot! — user1806735
– user1806735, Commented Nov 8, 2012 at 16:03

DonCallisto · Accepted Answer · 2012-11-08 16:02:39Z

1

SELECT COUNT(DISTINCT username)
FROM yourTableName
WHERE uristem = '/uristem/3'

answered Nov 8, 2012 at 16:02

DonCallisto

30k9 gold badges74 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

xray1986 · Accepted Answer · 2012-11-08 16:02:42Z

0

I suppose this is one table with 2 columns.

Select Count(Distinct username)
From Table
Where uristem = '/uristem/3'

answered Nov 8, 2012 at 16:02

xray1986

1,1683 gold badges10 silver badges28 bronze badges

Comments

Jocelyn · Accepted Answer · 2012-11-08 16:03:21Z

0

The following query will return the number of unique unsers that hit /uristem/3:

SELECT COUNT(DISTINCT `username`) AS nb
FROM `your_table`
WHERE `uristem`='/uristem/3'

answered Nov 8, 2012 at 16:03

Jocelyn

11.4k11 gold badges47 silver badges63 bronze badges

Collectives™ on Stack Overflow

SQL Query to find unique count

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related