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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy