Question: You want to return data from the CUSTOMER table only for a specific REP_ID, what SQL keywords would you use to limit the data? Write
BALANCE SELECT CUST_ID, FIRST_NAME, LAST_NAME, FROM CUSTOMER; Columns to include in the query results 1 2 3 Limit to 1000W SELECT CUST_ID, FIRST_NAME, LAST_NAME, BALANCE FROM CUSTOMER; Data will come from the CUSTOMER table Export/importi Wire Coll Content Joey RMC Result Grid Filter Rover Edit: CUST_ID FIRST NAME LAST NAME BALANCE 125 Smith 80.68 182 By Rufton 43.13 227 Sandra Pincher 156.38 294 Samantha Smith 58.60 314 Tom 17.25 375 Melanie Jackson 252 25 435 James Gonzalez 230.40 492 Elmer Backson 45.20 543 Angie Hendnds 315.00 610 Sally Cruz 8.33 721 Leslie Smith 166.65 795 Randy Blacksmith 61.50 MULL Query results
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
