Finding Updated Records

Plus de détails

Project "Goods Finder" WBS

par Irene P

Els albums dels Beatles

par Jaume BP

Future Perfect and Future Continuous

par Lia Ventura

Sajid's Submarine Sandwiches

par Arwa Shibly - T L Kennedy SS (2352)

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