1) For the SQL INSERT command, the keyword require single quotes around items fo

Question

1) For the SQL INSERT command, the keyword require single quotes around items for har columns, but not around items for Integer columns. (2) 2) The SQL command used to add new data to a table is 3) The SQL command used to add a new field to an existing table is 4) The SQL command to delete data from a table is 5) The SQL command to delete a table is 6) The.keyword may be added to the SELECT statement to prevent duplicate rows from displaying (2). 7) For two tables A and B the 8) The SQL keyword used with wildcard searches (%,-) is 9) Query results may be sorted using the 10) SQL stands for JOIN shows only records common in both tables. (2) clause (2).

Explanation / Answer

1.VALUES
   INSERT INTO tableName (column1, column2, column3, ...)
   VALUES (value1, value2, value3, ...);
2.   IF RECORD EXIST THEN
       UPDATE tableName
       SET column1 = value1, column2 = value2, ...
       WHERE condition;
   IF NOT EXIST
       INSERT INTO tableName (column1, column2, column3, ...)
       VALUES (value1, value2, value3, ...);
3.ALTER TABLE tableName ADD columnName datatype;
4.DELETE FROM tableName WHERE condition;
5.DROP TABLE tableName;
6.SELECT DISTINCT column1, column1.. FROM tableName
7.INNER JOIN OR INTERSECT
8.LIKE
   SELECT * FROM tableName WHERE column1 LIKE 'SSR%';
9.ORDER BY
       SELECT column1, column2, ...
       FROM tableName
       ORDER BY column1, column2, ... ASC|DESC;
       ASC --> Ascending
       DESC --> Descending
10. SQL stands for Structured Query Language

==

Thanks

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.