SQL INSERT INTO Statement

to insert new row(s) into a database table

they will be NULL

using multiple VALUES clauses separated by commas

<p>to modify existing records in a database table</p> Signup and view all the answers

<p>a WHERE clause</p> Signup and view all the answers

<p>UPDATE table_name SET column1 = value1, column2 = value2, ...</p> Signup and view all the answers

<p>The UPDATE statement is used to modify existing data in a table. It can be used to update multiple values in a single row by separating the column-value pairs with commas, as in <code>UPDATE Customers SET first_name = 'Johnny', last_name = 'Depp' WHERE customer_id = 1;</code></p> Signup and view all the answers

<p>You can update multiple rows in a table at once by specifying a condition in the WHERE clause that selects multiple rows, as in <code>UPDATE Customers SET country = 'NP' WHERE age = 22;</code></p> Signup and view all the answers

<p>The DELETE statement is used to delete rows from a table based on a condition, while the TRUNCATE TABLE statement is used to delete all rows from a table at once, without the need for a condition.</p> Signup and view all the answers

<p>You can delete a single row from a table by specifying a condition in the WHERE clause that selects a single row, as in <code>DELETE FROM customers WHERE id = 5;</code></p> Signup and view all the answers

<p>Omitting the WHERE clause in a DELETE statement will delete all rows from the table.</p> Signup and view all the answers

<p>You can update all rows in a table at once by omitting the WHERE clause, as in <code>UPDATE Customers SET country = 'NP';</code></p> Signup and view all the answers

<p>TRUNCATE can only remove all the records from a table, whereas DELETE can remove single, multiple, or all rows/records from a table.</p> Signup and view all the answers

<p>The SQL SELECT statement is used to select (retrieve) data from a database table.</p> Signup and view all the answers

<p>You can select all columns from a database table using the * character.</p> Signup and view all the answers

<p>The WHERE clause allows us to fetch records from a database table that matches specified condition(s).</p> Signup and view all the answers

<p>You must enclose textual data inside either single or double quotations.</p> Signup and view all the answers

<p>SQL DELETE supports the WHERE clause, whereas SQL TRUNCATE does not support the WHERE clause.</p> Signup and view all the answers

<p>It counts the number of unique rows.</p> Signup and view all the answers

<p>It is used to give columns or tables a temporary name.</p> Signup and view all the answers

<p>Using the AS keyword, for example: SELECT first_name AS name FROM Customers;</p> Signup and view all the answers

<p>It allows us to specify the number of records in the result set.</p> Signup and view all the answers

<p>It is used to specify the starting rows from where to select the data.</p> Signup and view all the answers

<p>For example: SELECT first_name, last_name FROM Customers LIMIT 2 OFFSET 3;</p> Signup and view all the answers

<p>The WHERE clause is used to construct conditions using operators to filter data. For example, <code>SELECT * FROM Customers WHERE first_name = 'John';</code></p> Signup and view all the answers

<p>The AND operator is used to combine two conditions where both must be true, whereas the OR operator is used to combine two conditions where at least one must be true. For example, <code>SELECT * FROM Customers WHERE last_name = 'Doe' AND country = 'USA';</code> and <code>SELECT * FROM Customers WHERE last_name = 'Doe' OR country = 'USA';</code></p> Signup and view all the answers

<p>You can combine multiple AND, OR, and NOT operators using parentheses to group conditions. For example, <code>SELECT * FROM Customers WHERE (country = 'USA' OR country = 'UK') AND age &amp;lt; 26;</code></p> Signup and view all the answers

<p>The SELECT DISTINCT statement is used to retrieve distinct values from a database table. For example, <code>SELECT DISTINCT age FROM Customers;</code></p> Signup and view all the answers

<p>You can use SELECT DISTINCT with multiple columns by separating them with commas. For example, <code>SELECT DISTINCT country, first_name FROM Customers;</code></p> Signup and view all the answers

<p>The SELECT statement without the DISTINCT keyword returns all rows, including duplicates, while the SELECT DISTINCT statement returns only unique values.</p> Signup and view all the answers