Here are some ways that SOQL differs from SQL.

No INSERT, UPDATE or DELETE statements, only SELECT
No command execution
No wild cards for fields; all fields must be explicitly typed
No JOIN statement; however, you can include information from parent objects like Select name, phone, account.name from contact
No UNION operator
Queries cannot be chained together

Cheers!!!