clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2805496 fiddles created (40756 in the last week).

create table employees(employee_id varchar(10), employee_name varchar(100)); insert into employees values ('emp10', 'Bryan Nelson'), ('emp12', 'Rosalyn Sanders'), ('emp13', 'Rose Tudler'), ('emp20', 'Julio Gomez'), ('emp30', 'Ian McGregor'), ('emp40', 'Anne Hatt');
6 rows affected
 hidden batch(es)


SELECT employee_id, employee_name FROM employees WHERE employee_id LIKE 'emp1%' OR employee_id LIKE 'emp3%';
employee_id employee_name
emp10 Bryan Nelson
emp12 Rosalyn Sanders
emp13 Rose Tudler
emp30 Ian McGregor
 hidden batch(es)


SELECT TOP 1 employee_id, employee_name FROM employees WHERE employee_id LIKE 'emp1%' OR employee_id LIKE 'emp3%';
employee_id employee_name
emp10 Bryan Nelson
 hidden batch(es)


SELECT TOP 3 employee_id, employee_name FROM employees WHERE employee_id LIKE 'emp1%' UNION ALL SELECT TOP 1 employee_id, employee_name FROM employees WHERE employee_id LIKE 'emp3%'
employee_id employee_name
emp10 Bryan Nelson
emp12 Rosalyn Sanders
emp13 Rose Tudler
emp30 Ian McGregor
 hidden batch(es)


SELECT employee_id, employee_name FROM employees WHERE employee_id LIKE 'emp[13]%'
employee_id employee_name
emp10 Bryan Nelson
emp12 Rosalyn Sanders
emp13 Rose Tudler
emp30 Ian McGregor
 hidden batch(es)