SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)
DELETE FROM table_name
If we want to allow age of a person > 18 in the column Age of table Person, then which constraint will be applied to AGE column.
In a table, a column contains duplicate value, if you want to list all different value only, then which SQL clause is used?
To give a temporary name to a table, or a column in a table for more readability, what is used?
Logical operators used in SQL are
AND, OR , NOT
To specify the number of records to return, which keyword is used
To search for a specified pattern in a column
To combine the result-set of two or more SELECT statements, SQL clause used is
Which is called as a virtual table in SQL?
The SQL join which does Cartesian product is called?