Select

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 *