SELECT ROW_NUMBER() OVER (PARTITION BY 'Total' ORDER BY COUNT(*) DESC) AS... |
2 years ago |
SELECT ROW_NUMBER() OVER (PARTITION BY 'Total' ORDER BY COUNT(*) DESC) AS... |
2 years ago |
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... |
2 years ago |
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as... |
2 years ago |
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as 'Total'
FROM
logging,... |
2 years ago |
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as 'Total'
FROM
logging,... |
2 years ago |
SELECT
COUNT(*) as 'Total'
FROM
logging, actor
WHERE
log_type=... |
2 years ago |