Rachel's crib sheet

Keyboard shortcuts

Cut, copy, paste

Shading

Other

SQL

SELECT COL1, COL2 FROM TABLENAME WHERE COL3 = VALUE

e.g. SELECT SID, NAME, TUTOR FROM STUDENTS WHERE GENDER='M'

Excel