Select - notshi/dquery GitHub Wiki

Select specifies the kind of data we want to get.

Include column names that you wish to select from the table.
Multiple column names are separated by a comma ,.

If column names are not provided, this defaults to an asterisk * which means everything. The valid values here depend on which tables you are querying.

The following lists the most common, but not all commands using Select.

Commands What it does
* Returns full acitivity information, in their original order
count(*) Returns a number of items
distinct Returns a list of unique results
aid Returns a list of identifiers
pid Returns a list of publishers

Examples

select distinct aid 
select *