loading..
Русский    English
13:23

Tag > MySQL

What is needed for work with the textbook?
Exercise #10 (tips and solutions)
Renaming the columns and calculations in the result set
INSERT statement
Adding rows to a table with identity column
DELETE statement
DATEDIFF function
DATEPART function [1,2]
ROW_NUMBER function
CHAR and VARCHAR
Float(n)
FULL JOIN and MySQL
More tags: FULL JOIN, NULL, UNION
Aggregate function to aggregate function
Integer division
The sorting and NULL values
CONCAT function
MySQL. Usage of query variables
Equivalent of recursive CTEs
More tags: recursive CTE
Equivalents for analytic functions [1,2]
More tags: window functions
Performance

Tags
aggregate functions Airport ALL AND AS keyword ASCII AVG Battles Bezhaev Bismarck C.J.Date calculated columns Cartesian product CASE cast CHAR CHARINDEX Chebykin check constraint classes COALESCE common table expressions comparison predicates Computer firm CONVERT correlated subqueries COUNT CROSS APPLY CTE data type conversion data types database schema date/time functions DATEADD DATEDIFF DATENAME DATEPART DATETIME DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates EXCEPT exercise (-2) exercise 19 exercise 23 exercise 32 More tags
The book was updated
month ago
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.
Rambler's Top100