Upgrade to remove ads
SQL Scripting Unit 1
Terms in this set (20)
When an aggregate Function is used, which clause divides the data into distinct groups?
What is an expression that tests one or more value expressions and returns true, false, or unknown?
What Keyword is used to eliminate any duplicate rows?
Which operator do you use when all the conditions you combine must be met in order for a row to be included in a result set?
What symbol is used to select all columns from a table?
Which Predicate lets you test whether the value of a given value expression falls within a specified range of values?
Which clause specifies the tables or views from which to retrieve data?
Which operator is used to include rows in the result set that did not meet the condition of the predicate?
A Saves SELECT statement is referred to as what?
Which predicate uses one of six operators to compare one value expressions to another value expressions?
Which comparison operator means less than or equal to?
Which clause is used to filter the results of aggregate functions?
What clause sorts the rows returned?
Which clause is used to filter non aggregate data?
Which comparison operator means not equal to?
The way a database software sorts data depends on the database software's what?
Which operator do you use when either of the conditions you combine can be met in order for a row to be included in a result set?
What is the primary clause in a SELECT statement?
Which predicate tests whether the value of a given value expression matches an item in a given list of values?
Which predicate enables you to test whether a character string value expression matched a specified character string pattern?
This set is often in folders with...
Database Administration Fundamentals
Managerial Accounting Quiz 2
You might also like...
SQL: Basic Queries
Murach's SQL Server 2016 - Chapter 3
C170 SQL Keywords
MySQL 2nd Edition Chapter 03
Other Quizlet sets
Head, Face, Thorax, Abdomen Special Tests
Unit 1- Matter and Change Study Guide (Hardy)
Medical Anthropology Midterm