Viewing 10 posts - 1 through 10 (of 10 total)
September 13, 2017 at 11:07 am
September 11, 2017 at 11:35 am
September 7, 2017 at 10:38 am
September 3, 2017 at 11:51 am
select table1.key, table2.price
from table1 left join table2 on (table1.key=table2.key)
where 2 = (select count( distinct price) mm from table2 where table1.price < table2.price);
September 3, 2017 at 10:48 am
Here A1/A2...
August 28, 2017 at 11:55 am
August 27, 2017 at 10:24 am
select id,
max(case when tab ='AB' and Name_approved=1 then 'Yes' else 'No' end) AS AB,
max(case when tab ='CD' and Name_approved=1 then 'Yes' else 'No' end) AS CD,
max(case...
August 20, 2017 at 11:28 am
August 17, 2017 at 11:53 am
SELECT column1 FROM table1 AS T1 INNER JOIN Params AS P1 ON T1.column LIKE '%' + P1.param + '%';
August 14, 2017 at 12:29 pm
Viewing 10 posts - 1 through 10 (of 10 total)