02:18
Content
Login
SQL Problems and solutions
S. I. Moiseenko
Content
SQL console
Tag >
calculated columns
Renaming the columns and calculations in the result set
More tags:
AS keyword
,
renaming columns
Last added:
Exercise #32
HAVING clause
Numbering of rows in accordance with the order of values of a primary key
Exercise #(-2) page 4
Exercise #(-2) (tips and solutions) page 2
Exercise #(-2) page 2
Exercise #(-2) page 3
Exercise #(-2)
Appendix 2. Exercises list page 3
Appendix 2. Exercises list page 2
Tags
tags search
aggregate functions
ALL
ASCII
AVG
Battles
Bezhaev
Bismarck
C.J.Date
Cartesian product
CASE
cast
CHAR
CHARINDEX
classes
COALESCE
common table expressions
comparison predicates
Computer firm
CONVERT
correlated subqueries
COUNT
CTE
data type conversion
database schema
DATEDIFF
DATEPART
DATETIME
DELETE
DISTINCT
EXCEPT
exercise (-2)
exercise 19
exercise 23
exercise 37
exercise 39
exercise 46
exercise 54
exercise 55
exercise 56
exercise 57
exercise 7
exercise 70
exercise 8
exercises
EXISTS
FROM
FULL JOIN
GROUP BY
grouping
Guadalcanal
More tags
HAVING
head ships
IDENTITY
IN
income
inner join
INSERT
INTERSECT
ISNULL
join operations
laptop
launched year
LEFT
LEFT OUTER JOIN
LEN
LTRIM
MAX
MIN
mistakes
MySQL
NOT IN
NULL
number sequences
number-sequence generation
numbering
ORDER BY
outcome
Outcomes
outer joins
OVER
paging
PARTITION BY
PATINDEX
PC
PIVOT
PostgreSQL
predicates
printer
product
Ranking functions
recursive CTE
REPLACE
RIGHT
ROW_NUMBER
ships
SQL Server
SQL-92
sql-ex.ru
string functions
subquery
SUBSTRING
tables join
tips and solutions
Torus
Transact-SQL
type conversion
UNION
UNION ALL
UNKNOWN
UPDATE
varchar
WHERE
window functions
WITH
упражнение 23
The book was updated
yesterday