Management Information Systems (MIS) > QUESTIONS & ANSWERS > WGU Data Management - Applications - C170 OA GSA1 (All)
WGU Data Management - Applications - C170 OA GSA1
Document Content and Description Below
WGU Data Management - Applications - C170 OA GSA1 Add New Row Answer- INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row Answer- UPDATE table_name SET ... column1 = value1, column2 = value2, ... WHERE condition; Delete Row Answer- DELETE FROM table_name WHERE condition; Inner Join Answer- SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name; CREATE VIEW Answer- CREATE VIEW viewname AS SELECT Col1, Col2 FROM table WHERE condition; Concatenate Answer- CONCAT(Col1, Col2) AS NewColumnName; [Show More]
Last updated: 3 years ago
Preview 1 out of 2 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
.png)
Reviews( 0 )
$3.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Sep 16, 2022
Number of pages
2
Written in
All
Additional information
This document has been written for:
Uploaded
Sep 16, 2022
Downloads
0
Views
150
