Using a SELECT statement
Use a SELECT statement to retrieve a results set from a table as standard output or in JSON format.
Functions allow you to manipulate the column values or aggregate the entire results set of specific columns.
SELECT column_list FROM [<keyspace_name>.]<table_name>
[WHERE <primary_key_conditions>[ AND clustering_columns_conditions]] | PRIMARY KEY LIMIT