Filter your SQL table for the information you need by using the WHERE clause!
Queries using WHERE:
1) Filter your query based on an exact match: SELECT * FROM table WHERE column='value'
2) Filter your query using Wildcards to match a pattern: SELECT * FROM table WHERE column LIKE '%str%ing%'
3) Filter your query using numeric operators: SELECT * FROM table WHERE column < 5
4) Beef up your filters by using the AND & OR statements: SELECT * FROM table WHERE (column1 < 5 AND column2 LIKE '%a%') OR column3 = 1
5) Exlude info from you query using the NOT clause: SELECT * FROM table WHERE NOT column1 = 1
6) Pull a range of information using the BETWEEN clause: SELECT * FROM table WHERE column1 BETWEEN 1 AND 5
7) Extract all the NULL or NOT NULL values out of your table: SELECT * FROM table WHERE column1 IS NULL
Get the Northwind Database: • How to Load a Sample PostgreSQL Database i...
Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:
Поделиться в:
Доступные форматы для скачивания:
Скачать видео mp4
Информация по загрузке:
Скачать аудио mp3
Похожие видео
array(10) {
[0]=>
object(stdClass)#4741 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "jcoJuc5e3RE"
["related_video_title"]=>
string(64) "Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)"
["posted_time"]=>
string(19) "5 лет назад"
["channelName"]=>
string(25) "Becoming a Data Scientist"
}
[1]=>
object(stdClass)#4714 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "GpC0XyiJPEo"
["related_video_title"]=>
string(41) "How to do Subqueries in SQL with Examples"
["posted_time"]=>
string(19) "5 лет назад"
["channelName"]=>
string(25) "Becoming a Data Scientist"
}
[2]=>
object(stdClass)#4739 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "nNrgRVIzeHg"
["related_video_title"]=>
string(64) "Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)"
["posted_time"]=>
string(19) "5 лет назад"
["channelName"]=>
string(25) "Becoming a Data Scientist"
}
[3]=>
object(stdClass)#4746 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "5x1uodxEIaM"
["related_video_title"]=>
string(75) "SQL CTE (Common Table Expression) Full Guide | WITH Clause | #SQL Course 28"
["posted_time"]=>
string(27) "9 месяцев назад"
["channelName"]=>
string(15) "Data with Baraa"
}
[4]=>
object(stdClass)#4725 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "5t1fW3KG920"
["related_video_title"]=>
string(35) "SQL Indexes Explained in 20 Minutes"
["posted_time"]=>
string(28) "11 месяцев назад"
["channelName"]=>
string(13) "developedbyed"
}
[5]=>
object(stdClass)#4743 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "GO9Gu_hfoD4"
["related_video_title"]=>
string(83) "Оконные функции RANK и LAG | Симулятор SQL | karpov.courses"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
string(14) "karpov.courses"
}
[6]=>
object(stdClass)#4738 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "5tEApCGgpEQ"
["related_video_title"]=>
string(39) "5 Basic SELECT Statement Queries in SQL"
["posted_time"]=>
string(19) "5 лет назад"
["channelName"]=>
string(25) "Becoming a Data Scientist"
}
[7]=>
object(stdClass)#4748 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "blWdjRUPP6E"
["related_video_title"]=>
string(72) "Разведчик о том, как использовать людей"
["posted_time"]=>
string(25) "3 недели назад"
["channelName"]=>
string(18) "Коллектив"
}
[8]=>
object(stdClass)#4724 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "cY4pVLpjL3g"
["related_video_title"]=>
string(60) "⚡ SQL Joins Visualized: The Ultimate Guide for Developers!"
["posted_time"]=>
string(25) "3 месяца назад"
["channelName"]=>
string(8) "ByteMonk"
}
[9]=>
object(stdClass)#4742 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "9yeOJ0ZMUYw"
["related_video_title"]=>
string(68) "SQL Joins Explained |¦| Joins in SQL |¦| SQL Tutorial"
["posted_time"]=>
string(19) "6 лет назад"
["channelName"]=>
string(9) "Socratica"
}
}
