| Basic Select |
Revising the Select Query II |
MS SQL Server |
select from where and |
|
Select All |
MS SQL Server |
select * |
|
Select By ID |
MS SQL Server |
|
|
Japanese Cities' Attributes |
MS SQL Server |
|
|
Japanese Cities' Names |
MS SQL Server |
|
|
Weather Observation Station 1 |
MS SQL Server |
|
|
Weather Observation Station 3 |
MS SQL Server |
id%2 for MS SQL, mod(id,2) for ORACLE |
|
Weather Observation Station 4 |
MS SQL Server |
count |
|
Weather Observation Station 5 |
MS SQL Server |
length order top 1 |
|
Weather Observation Station 6 |
MS SQL Server |
distinct where like '[AEIOU]%' |
|
Weather Observation Station 7 |
MS SQL Server |
right(, 1) in ('','') |
|
Weather Observation Station 8 |
MS SQL Server |
and |
|
Weather Observation Station 9 |
MS SQL Server |
'[^AEIOU]%' |
|
Weather Observation Station 10 |
MS SQL Server |
not in |
|
Weather Observation Station 11 |
MS SQL Server |
not() logic either not or not |
|
Weather Observation Station 12 |
MS SQL Server |
logic neither nor |
|
Higher Than 75 Marks |
MS SQL Server |
order by right(, 3), id asc |
|
Employee Names |
MS SQL Server |
order by string (default asc) |
|
Employee Salaries |
MS SQL Server |
|
| Advanced Select |
The PADS |
MS SQL Server |
concat select "str", count() group by order by , |
|
Occupations |
MS SQL Server |
pivot table |
| Aggregation |
Revising Aggregations - The Sum Function |
MS SQL Server |
select sum() where str = '' |
|
Revising Aggregations - Averages |
MS SQL Server |
avg |
|
Average Population |
MS SQL Server |
round down to integra floor() |
|
Japan Population |
MS SQL Server |
|
|
Population Density Difference |
MS SQL Server |
|
|
The Blunder |
MS SQL Server |
ceiling, cast(() as decimal), replace(str,'0','') |
|
Top Earners |
MS SQL Server |
|
|
Weather Observation Station 2 |
MS SQL Server |
format(,'.##') |
|
Weather Observation Station 13 |
MS SQL Server |
between and |
|
Weather Observation Station 14 |
MS SQL Server |
|
|
Weather Observation Station 15 |
MS SQL Server |
|
|
Weather Observation Station 16 |
MS SQL Server |
|
|
Weather Observation Station 17 |
MS SQL Server |
|
|
Weather Observation Station 18 |
MS SQL Server |
Manhattan Distance max()-min() or abs( - ) |
|
Weather Observation Station 19 |
MS SQL Server |
Euclidean Distance, power( , 2), sqrt(), square(), cannot use ()^2 for int |
|
Weather Observation Station 20 |
MS SQL Server |
median |
| Basic Join |
African Cities |
MS SQL Server |
inner join, in(), on = |
|
Average Population of Each Continent |
MS SQL Server |
avg(), group by |
|
The Report |
MS SQL Server |
select case when then else end, order by desc |
|
Top Competitors |
MS SQL Server |
group by, having, order by have same name with select |
|
Ollivander's Inventory |
MS SQL Server |
double select from same tables (as different name) |
|
Challenges |
MS SQL Server |
|
|
|
MS SQL Server |
|
| Alternative Queries |
Draw The Triangle 2 |
MS SQL Server |
declare @row int =, while() begin, set @row += 1, end, replicate |
|
|
MS SQL Server |
|
|
|
MS SQL Server |
|
|
|
MS SQL Server |
|
| Big Query |
Regex Queries |
MS SQL Server |
Regex |
|
Performance of Joins |
MS SQL Server |
JOIN EACH |
|
The Query |
MS SQL Server |
|
|
|
MS SQL Server |
|
|
|
MS SQL Server |
|
|
|
MS SQL Server |
|
|
|
MS SQL Server |
|
|
|
MS SQL Server |
|
