Finding Updated Records

Mere som dette

A Modern History of Track & Field

af Conway's Maps

Sample Mind Map

af Menna Covarrubias

The Day the Crayons Quit

af Zara Khan - Centennial Sr PS (1506)

Sample Mind Map

af Fernando Ayala

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