SQL - NoSleepCreative Wiki

Search…

SQL

Recommended Readings
Item
Links
Documentation / Tutorials
​SQL for Beginners​
​Management Information Systems Careers​
Industry / 
Case-studies 
​
Books
​
Cheatsheet
​
​https://www.sqltutorial.org/sql-cheat-sheet/​
Luke Harrison: https://websitesetup.org/sql-cheat-sheet/​
1
select
2
from
3
where
4
order by [desc]
Copied!
Google Sheets
​Multiple contains ​
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!

Code - Previous

Terminal

Next - Code

Webscraping

Last modified 1yr ago

Copy link

Contents

Recommended Readings

Google Sheets

​Multiple contains ​

Referencing cells in query

Hyperlinks

Multiple contains