Русский    English


1900-01-01 Acknowledgements AGE aggregate functions Airport ALL AND ANSI_NULLS ANY AS keyword ASCII attribute autoincrementable column AUTO_INCREMENT average value AVG balloon Battles Ben-Gan between Bezhaev bibliography Bismarck BOOLEAN C.J.Date calculated columns Cartesian product CASE cast CD drive CEILING CHAR CHARACTER STRING CHARINDEX Chebykin check constraint classes COALESCE collation common table expressions Company comparison predicates Computer firm CONTINUE IDENTITY CONVERT correlated subqueries Cortazar COUNT COUNT(1) CREATE SEQUENCE CREATE TABLE CROSS APPLY CROSS JOIN CTE data type conversion data types database schema DATALENGTH date/time functions DATEADD DATEDIFF DATENAME DATEPART DATETIME DATE_PART DBMS DDL DECIMAL DEFAULT DEFAULT VALUES DELETE delimited identifier DENSE_RANK DIFFERENCE DISTINCT DIV DML DML exercises domain duplicates E.F.Codd EPOCH equations root equi-join escape character EXCEPT EXEC exercise (-2) exercise 1 exercise 10 exercise 11 exercise 13 exercise 15 exercise 16 exercise 17 exercise 18 exercise 19 exercise 2 exercise 23 exercise 24 exercise 25 exercise 26 exercise 27 exercise 3 (rating) exercise 30 exercise 32 exercise 37 exercise 38 exercise 39 exercise 43 exercise 46 exercise 5 exercise 51 exercise 53 exercise 54 exercise 55 exercise 56 exercise 57 exercise 59 exercise 6 exercise 60 exercise 7 exercise 70 exercise 71 exercise 77 exercise 78 exercise 8 exercise 93 exercises exercises 18 exist EXISTS EXTRACT FETCH first day of the week FLOAT FLOOR FOREIGN KEY FROM FULL JOIN generate_series GROUP BY grouping Guadalcanal HAVING head ships Hopscotch IDENTITY IDENTITY_INSERT IN income income_o INITCAP inner join INSERT integer division INTERSECT INTERSECT ALL INTERVAL IS NOT NULL IS NULL ISNULL Itzik Ben-Gan J. Celko J.D.Ullman J.Widom Joe Celko join operations Kalen Delaney laptop launched year leap year learning stage LEFT LEFT OUTER JOIN LEN LIKE LIMIT logical operators Lorus LOWER LTRIM maker Martin Gruber MAX Mercadot MIN MINUS MINUTE mistakes MOD modify money MONTH MySQL NATURAL JOIN NCHAR NEWID nodes NOT NOT EXISTS NOT IN NULL NULLIF NULLS FIRST NULLS LAST number sequences number-sequence generation numbering NUMERIC OFFSET ON DELETE CASCADE OR Oracle ORDER BY outcome Outcomes outcome_o OUTER APPLY outer joins OVER paging Painting PARTITION BY Passenger Pass_in_trip PATINDEX PC PIVOT PostgreSQL POWER PRECEDING predicates primary key printer problems and solutions product query query console query execution plan query optimization QUOTED_IDENTIFIER RAND random sampling of rows RANGE RANK Ranking functions recursive CTE recycled materials Recycled materials company regular expressions relation relational division Relational model remainder of division renaming columns REPLACE REPLICATE RESTART IDENTITY REVERSE RIGHT RIGHT JOIN RND ROUND rounding row constructor ROWNUM ROW_NUMBER RTRIM running totals select SELECT statement self-join SERIAL SET DATEFIRST SET LANGUAGE ships sorting SOUNDEX SPACE sql SQL Server SQL Server 2000 SQL Server 2012 SQL Standard SQL-92 stored procedure STR string comparison string functions STUFF subquery substraction SUBSTRING SUM sunken ships table constructor tables join teaching sql The order of execution of clauses in SELECT state Three-valued logic TIMESTAMP TIMESTAMPDIFF TINYINT tips and solutions TOP N WITH TIES Torus TO_CHAR trailing spaces Transact-SQL Trip TRUNCATE TABLE tuple type conversion typical problems UNBOUNDED UNICODE UNION UNION ALL UNION JOIN uniqueness UNKNOWN UNPIVOT UPDATE UPPER utB utQ utV value VALUES varchar WHERE wildcard character window functions WITH WITH TIES XML XPath XQuery YEAR строковые функции упражнение 23
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.
Rambler's Top100