Sunday, May 15, 2011

Query - Combination of columns

select * FROM tmpTable sc WHERE sc.file_id = 681 and (sc.colA,sc.colB) in (('ABC',55), ('FED',54));

No comments: