Question

Evaluate these two sql statements: 1. select concat(first_name, last_name), length(concat(first_name, last_name)) from employee where upper(last_name) like '%j' orupper(last_name) like '%k' orupper(last_name) like '%l'; 2. select initcap(first_name) || initcap(last_name), length(last_name) + length(first_name) from employee where initcap(substr(last_name, 1, 1)) in ('j', 'k', 'l'); how will the results differ?

Answer 1

by 1 step back to back.....