Sql Query : General Knowledge Questions & Answers
Question : Which of the following is a legal expression in SQL?
A.
SELECT NULL FROM SALES;
B.
SELECT NAME FROM SALES;
C.
SELECT * FROM SALES WHEN PRICE = NULL;
D.
SELECT # FROM SALES;
Correct Answer is : Option B.
- DCL provides commands to perform actions like
- The COUNT function in SQL returns the number of ______________
- Which data type can store unstructured data in a column?
- A SQL query will not work if there are no indexes on the relations - Is it true ?
- Which function is used to divides one numeric expression by another and get the remainder ?