Examples of using Write queries in English and their translations into Romanian
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Ecclesiastic
-
Computer
-
Programming
Write queries that use dynamic SQL.
Describe the built-in aggregate function in SQL Server and write queries using it.
Write queries using the OUTER APPLY operator.
This module describes write queries that pivot and unpivot result sets.
Write queries using the CROSS APPLY operator.
Write queries that use built-in functions.
Write queries that use the GROUPING_ID function.
Write queries using the GROUPING SETS subclause.
Write queries that return results from views.
Write queries that use window aggregate functions.
Write queries that use window ranking functions.
Write queries that separate rows using the GROUP BY clause.
Write queries that use UNION to combine input sets.
Write queries that use the HAVING clause to filter groups.
Write queries which combine data using the UNION operator.
Write queries that create and retrieve results from derived tables.
Write queries that use correlated subqueries in a SELECT statement.
Write queries that specify multiple groupings with grouping sets Lessons.
Write queries that create CTEs and return results from the table expression.
Write queries that use window ranking, offset, and aggregate functions.
Write queries that pivot data from rows to columns using the PIVOT operator.
Write queries that unpivot data from columns back to rows using the UNPIVOT operator.
Write queries that use the EXCEPT operator to return only rows in one set but not another.
Write queries that use the OVER clause, with partitioning, ordering, and framing to define windows.
Write queries that use the INTERSECT operator to return only rows that are present in both sets.
Write queries that use EXISTS predicates in a WHERE clause to test for the existence of qualifying rows.
This module describes the elements of T-SQL and their role in writing queries.
Writing queries that contain the WHERE clause to limit the data returned.
Writing queries using ORDER BY clause to sort the output of a query. .
Practical skills for writing queries.