Open
Description
I would like to do sth following:
select t1.* from <table_1> as t1
where t1.firstname in (select t2.firstname from (select distinct firstname from <table_1> order by firstname) t2)
order by t1.lastname
Does it support sub-query function?