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/​
select
from
where
order by [desc]
Google Sheets
​Multiple contains ​
=QUERY(A1:A,"Select * Where not A Matches '.*AB.*|.*DJ.*' ",1)
=query(C323:C335,"Select C where not C contains 'soccer'")
=QUERY(C:C,"Select C Where not C Matches '.*ezoic.*|.*soccer.*' ",1)
​
Referencing cells in query 
query(sheet2!A:G,"select A where G contains '"&L3&"'")
​
=query(SX_Sessions!$B$2:$E$120, 
"select B,D 
where E ='" &B3&"' 
AND C = '"&$B$1&"'")
Hyperlinks
=IMPORTXML(B3, "//a/@href")

Code - Previous

Terminal

Next - Code

Webscraping

Last modified 2yr ago

Copy link

Outline

Recommended Readings

Google Sheets

​Multiple contains ​

Referencing cells in query

Hyperlinks

Multiple contains