<http://schema.org/articleBody>
"I would like to select 5 rows (of thousands) where field1 = 'A' and union that with 5 rows where field1 = 'B' How can I accomplish this with sql? Thanks! I have tried variations of select * from file1 where field1 = 'A' FETCH FIRST 5 ROWS ONLY union select * from file1 where field1 = 'B' FETCH FIRST 5 ROWS ONLY ______________________________________________________________________ This outbound email has been scanned for all viruses by the MessageLabs Skyscan service. For more information please visit http:..."^^<http://www.w3.org/2001/XMLSchema#string>
<http://archive.midrange.com/midrange-l/201403/msg00648.html>