Critical Thinking Questions
Case 10-2
?
An employee at PrattLast Associates needs to create an additional SQL query. She needs to sort records by current due within account manager number.
How can she ensure that no duplicate records appear in the query result?
a. Include the DISTINCT operator in the SQL command. b. Include the SELECT operator in the SQL command. c. Include the ORDER BY operator in the SQL command. d. Include the SEQUEL operator in the SQL command.
What will be an ideal response?
Answer: A
Computer Science & Information Technology
You might also like to view...
The Java compiler allows you to store an int value in a char variable without an explicit type conversion.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
Hold down the ________ key to select a group of files that are together in the file list
Fill in the blank(s) with correct word
Computer Science & Information Technology
In the following expression, what purpose does the & symbol serve?
="Between"&[Enter first date]&"and"&[Enter the second date] A) Separates the words B) Concatenates the words together C) Inserts a dash between the words D) Inserts a space between the words
Computer Science & Information Technology
In most tables, one of the fields uniquely identifies each record and is called the ____.
A. exception B. foreign key C. primary key D. cell
Computer Science & Information Technology