Page 1 of 1
3. Customerid is key in both Orders O and Customers C tables. Complete below to select records that exists in both table
Posted: Fri Jul 08, 2022 6:44 am
by answerhappygod
- 3 Customerid Is Key In Both Orders O And Customers C Tables Complete Below To Select Records That Exists In Both Table 1 (80.8 KiB) Viewed 53 times
3. Customerid is key in both Orders O and Customers C tables. Complete below to select records that exists in both tables. SELECT O.orderid, O.desc, C.name FROM Orders O 4. Update TableA to add 100 on salary for primary key emp_id = 10 UPDATE TableA 5. Complete below SQL
statement to find count of records from Customers table. SELECT Country, State, City, Count(*) AS Count FROM Customers 6. Add FK on child_table (column1) refrencing from parent_table (column1). ALTER TABLE child_table