Ask a Question
  
  
  
Top Posters
Since Sunday
50
34
28
15
13
13
12
12
12
11
10
10
New Topic  
wrote...
Posts: 239
Rep: 0 0
A week ago
The following database will be used in this question:

GENERAL SALES DATABASE:

SALESREP
SalesRepNoRepNameHireDate
654Jones01/02/2005
734Smith02/03/2007
345Chen01/25/2018
434Johnson11/23/2004

CUSTOMER
CustNoCustNameBalanceSalesRepNo
9870Winston500345
8590Gonzales350434
7840Harris800654
4870Miles100345

Explain the use of the of SQL keyword SELECT. Include an example based on the CUSTOMER table in the General Sales database.
Source  Download Study Guide
Test Bank for Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 80 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 179
A week ago
Sign in or Sign up in seconds to unlock everything on Biology Forums.
The SQL keyword SELECT forms the basis for all SQL querying. Although SELECT technically specifies columns to be used in a query, it is always the first SQL keyword or command in an SQL phrase that includes at least the SQL keyword FROM and often the SQL keyword WHERE. The SQL keyword FROM is used to specify which tables are used in the query, while the SQL keyword WHERE is used to specify conditions or constraints imposed on the query. For example,

SELECT *
FROM CUSTOMER
WHERE CustNo = 8590;

is a query that returns all information in the table CUSTOMER about the customer whose customer number is 8590.
This verified answer contains over 130 words.
Related Topics
wrote...
A week ago
Brilliant
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  81 People Browsing
 114 Signed Up Today
Related Images
 58
 97
 31
Your Opinion
Who's your favorite biologist?
Votes: 15