Question
How N is related to Q?
Answer the questions based on the information given below. There are only six members in three generation family. % means Son. # means Husband. @ means Daughter. $ means Wife. Q is @ of L, who is # of P. O is % of M, who is $ of N. M has two %.Solution
Which SQL function returns the number of rows in a table?
Which SQL clause is used for filtering rows?
Recursive CTEs are mainly used for:
Materialized views differ from normal views because:
ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
Which of the following can be used to avoid duplicate entries in a column?
Which SQL keyword prevents duplicate rows in result?
What is the output of this SQL snippet if the price column contains NULL values?
SELECT SUM(price) FROM products;
A materialized view differs from a normal view because it:
Which SQL command is used to remove a table completely?