Using a LEFT JOIN To isolate the uncommon rows in the table one SELECT t1.*FROM Table1 t1LEFT JOIN Table2 t2 ON t1.id = t2.idWHERE t2.id IS NULL; using Except if database supports. SELECT * FROM Table1EXCEPTSELECT * FROM Table2; UNQORK In unqork we use datawork flow. the merge operator is used with outer option. upper […]
PHP query Vs Unqork
id name salary 23546 Anna 700000 23452 Bintu 670000 23453 Caddy 800000 account Q1) Get the row which has salary = 700000 PHP Unqork Q1) Get the rows which has salary greater than 700000 PHP Unqork
