Test your skills through the online practice test: SQL Quiz Online Practice Test

Related differences

Ques 71. The Delete Statements:

DELETE FROM WITHOUTBOOK WHERE NAME='JOHN';

Is it helpful? Add Comment View Comments
 

Ques 72. Sort the Rows:

SELECT * FROM WITHOUTBOOK ORDER BY NAME ASC;
SELECT * FROM WITHOUTBOOK ORDER BY NAME DESC;

Is it helpful? Add Comment View Comments
 

Ques 73. The IN operator may be used if you know the exact value you want to return for at least one of the columns.

SELECT * FROM WITHOUTBOOK WHERE NAME IN(SELECT NAME FROM WITHOUTBOOK_BACK WHERE ADDRESS='KOLKATA, INDIA');

Is it helpful? Add Comment View Comments
 

Ques 74. BETWEEN ... AND

SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2 The values can be numbers, text, or dates.

Is it helpful? Add Comment View Comments
 

Ques 75. What is the use of CASCADE CONSTRAINTS?

When this clause is used with the DROP command, a parent table can be dropped even when a child table exists.

Is it helpful? Add Comment View Comments
 

Most helpful rated by users: