Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1.3 Which of the following statements are correct about the WHERE clause? A. Column Alias can be used in WHERE clause to refer a column
1.3 Which of the following statements are correct about the WHERE clause? A. Column Alias can be used in WHERE clause to refer a column B. Comparison operator is an optional element in WHERE clause condition C. Functions can be used as operands in the WHERE clause D. There can be multiple WHERE clause in a SELECT query 1.4 Which of the following is true about the SQL query given below? Select COL1, COL2 From TABLE Where COL1 = 'A' ORDER BY COL2 DESC, COL1; A. It will display the row which has the COL1 value as 'A' ordered by the COL1 in the descending order and then COL2 in the descending order. B. The ORDER BY clause will not work as the keyword DESC should be always written in the end of the ORDER BY clause and not in between as given in the query. C. The above query will be sorted in descending order based on COL2 only and the use of COL1 in the ORDER BY clause will be discarded. D. It will display the row which has the COL1 value as 'A' ordered by the COL1 and then followed by COL2 as the execution of the ORDER BY clause happens from the order of columns in the SELECT statement
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started