Example: Count the Number of Rows Stored in QryLogClientAttrV
The following SELECT statement counts all the rows stored in QryLogClientAttrV.
SELECT count(*) FROM dbc.qrylogclientattrv;
Result:
Count(*) ----------- 3
Example: SELECT All Rows
The following SELECT statement retrieves all the rows stored in QryLogClientAttrV.
SELECT * FROM dbc.qrylogclientattrv;
Result:
QueryID 307181787909344876 DateFld 16/03/02 TimeFld 07:26:04.68 UserName USER1 AccountName DBC Event Logon LogicalHostId 1 IFPNo 30718 SessionNo 1,465 LogonDate 16/03/02 LogonTime 07:26:04.64 […] QueryID 307181787909344874 DateFld 16/03/02 TimeFld 07:25:56.62 UserName DBC AccountName DBC Event Logon LogicalHostId 1 IFPNo 30718 SessionNo 1,464 LogonDate 16/03/02 […] QueryID 307181787909344878 DateFld 16/03/02 TimeFld 07:26:08.04 UserName DBC AccountName DBC Event Logon LogicalHostId 1 IFPNo 30718 SessionNo 1,466 LogonDate 16/03/02 […]