Table contains the following cols:
timestamp, date, customer_id, page_id
For example,
Query is: for each customer, identify the first "page_id" that customer visited most recent day.
If there is a "read-only access" databse. Are queries written differently?
Thanks in advance.
>Solution :
Read-only access means you can only read and do query’s that can read the database.
You won’t be able to insert,update or drop tables.