SQL Questions et reponses d'entretien
Question 71. The Delete Statements:
DELETE FROM WITHOUTBOOK WHERE NAME='JOHN';
Question 72. Sort the Rows:
SELECT * FROM WITHOUTBOOK ORDER BY NAME ASC;
SELECT * FROM WITHOUTBOOK ORDER BY NAME DESC;
Question 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');
Question 74. BETWEEN ... AND
SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2 The values can be numbers, text, or dates.
Question 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.
Les plus utiles selon les utilisateurs :