Consider the following "staff" table staff_name staff_dep city Riaz CSE Dhaka Toha EEE Rajshahi What should be the query to find the output like…

Consider the following "staff" table

staff_namestaff_depcity
RiazCSEDhaka
TohaEEERajshahi

What should be the query to find the output like "Riaz(CSE)" from the staff table?

  1. a) select staff_name || '('|| staff_dep ||')' FROM staff where city= 'Dhaka'
  2. b) select staff_name '('|| staff_dep ||')' FROM staff where city== 'Dhaka'
  3. c) select staff_name || '('|| staff_dep ')'|| FROM staff where city= 'Dhaka'
  4. d) select staff_name || '(' staff_dep ||')' FROM staff where city= 'Rajshahi'

From the Sonali Bank Assistant Database Administrator 2020 – Preliminary exam, question 21 of 68.

More from this paper