Finding Updated Records

Mer som dette

Phil Evans & Jose Figueroa - Cultural management

Ved Phil Evans

Business Presentation Diego Acero 9D #1

Ved Diego acero 98

defined articles

Ved Sandra Elizabeth

CX restaurant

Ved Alejandro Martinez

Find the last time each bike was in use. Output both the bike number and the date-timestamp of the bike's last use (i.e., the date-time the bike was returned). Order the results by bikes that were most recently used.

FROM dc_bikeshare_q1_2012

ORDER BY end_time [DESC]

SELECT bike_number, end_time,

Finding Updated Records

Find the current salary of each employee assuming that salaries increase each year.

GROUP BY

WHERE

WHERE condition;

FROM

FROM table_name;

Subtopic

SELECT

SELECT column1, column2, ...

id, first_name, last_name, salary, department_id

Table Name: ms_employee_salary id: int first_name: varchar last_name: varchar salary: int department_id: int