SQL Queries - CAST Knowledge Base - Queries on Links - How to count the Links in Knowledge Base

Created by Amine Benarbia on Feb 11, 2022
Purpose of Query

The query retrieve the number of links on the Knowledge base.

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS(tick)
Query for CSS
SELECT Count(*) 
FROM   acc
Query result example
 31385
Query result interpretation
 Number of links on the knowledge base.
Query for Oracle
SELECT Count(*) 
FROM   acc
Query result example
 31385
Query result interpretation
 Number of links on the knowledge base.
Query for SQL server
SELECT Count(*) 
FROM   acc
Query result example
 31385
Query result interpretation
 Number of links on the knowledge base.
Notes/comments



Related Pages