Question
What is the result of SELECT COALESCE(NULL, NULL, 5,
10);?Solution
COALESCE returns the first non-NULL value among its arguments.
More Data Warehousing Questions
How is Z related to X?
- A, B and C are siblings. B’s mother is daughter of K. K is wife of M, whose son-in-law is brother of L. How is C’s mother related to L?
Aman is brother of Priya who is married to Mehul. If Mehul is father of Amit who is father in law of Rahul, then how Priya is related to Rahul’s wife?...
Which of the following combinations of day-friend-company-colour is correct?
How is ‘B’ related to ‘E'?
- Arshi is mother of Rekha. Sunita is sister-in-law of Rekha. Tapan is maternal grandfather of Girish. Anuj is son of Puneet. If Arshi is mother of a son and...
There are eight members in the family J, K, L, M, N, O, P and Q with the three generations. No single person in the family is a parent. U is the mother ...
- Mohan is son of Akash. Manchun is father-in-law of Akash. Kamla is daughter-in-law of Paravati who is married to grandfather of Mohan. How is Kamla related...
E + F means E is daughter of F. E - F means E is husband of F. E × F means E is sister of F. E ÷ F means F is father of E. If L + M – N + O × P –...
- A is uncle of B who is son of D, but D is neither brother nor sister of A. A’s father is husband of L. L’s daughter H is mother of F. How is B related ...
