Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

12 cards

()

Section 1

Preview this deck

Select all columns in foo table

Front

1 / 12

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (12)

Section 1

(12 cards)

Select all columns in foo table

Front

SELECT * FROM foo

Back

Keyword used to filter results

Front

WHERE

Back

Count the number of rows in table foo

Front

SELECT COUNT(*) FROM foo;

Back

Select 2 records from all columns in table foo

Front

SELECT * FROM foo LIMIT 2;

Back

Select values from the year column from the foo table but only for values after year 2000

Front

SELECT year FROM foo WHERE year > 2000;

Back

Closing symbol for queries

Front

;

Back

Does not equal symbol in SQL

Front

<>

Back

Select the x and y columns in the foo table

Front

SELECT x, y FROM foo

Back

Select only unique values from column x in foo table

Front

SELECT DISTINCT x FROM foo;

Back

SQL stands for

Front

Structured Query Language

Back

Count number of non-missing names in foo table

Front

SELECT COUNT(names) FROM foo;

Back

Count the number of unique values in the name column in foo table

Front

SELECT COUNT(DISTINCT names) FROM foo;

Back