After Effects
Code
Software & Tutorials
SQL
Recommended Readings
Item
Links
Documentation / Tutorials
Industry /
Case-studies
- ​
Books
- ​
Cheatsheet
​
1
select
2
from
3
where
4
order by [desc]
Copied!
Google Sheets
1
=QUERY(A1:A,"Select * Where not A Matches '.*AB.*|.*DJ.*' ",1)
2
=query(C323:C335,"Select C where not C contains 'soccer'")
3
=QUERY(C:C,"Select C Where not C Matches '.*ezoic.*|.*soccer.*' ",1)
4
​
Copied!
Referencing cells in query
1
query(sheet2!A:G,"select A where G contains '"&L3&"'")
2
​
3
=query(SX_Sessions!$B$2:$E$120,
4
"select B,D
5
where E ='" &B3&"'
6
AND C = '"&$B$1&"'")
Copied!
Hyperlinks
1
=IMPORTXML(B3, "//a/@href")
Copied!
Last modified 1yr ago