View Single Post
  #2 (permalink)  
Old April 25th, 2018, 11:46 AM
eel3720 eel3720 is offline
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2018
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Create the sub query and then count rows

SELECT Count(*) AS N
FROM (SELECT DISTINCT EQUIP FROM tblskid) AS T;
Reply With Quote