Recent content by swampBoogie

select A.c1, A.c2, A.c3, case when exists (select 1 from B where B.id = A.idFromB and B.c1 = somevalue and B.c2 = somevalue) then 1 else 0 end as...

Standard sql only allows for column references in a group by clause. You can neither use expressions nor correlation names.

You can not use a column correlation name in other expressions, except in the order by clause. The general technique is select a + b from (select <expression> as a, <expression> as b, ... from ...) dt

Isnull is not standard SQL. Coalesce is.

It's called overlay in standard SQL. It has the bloated syntax OVERLAY(<expression> PLACING <expression> FROM <numeric value expression> [FOR <numeric value expression>]) I haven't seen any DBMS with support for this.

select customer_no from store_a_customer_tran where tran_type_cd = 'Z' union select customer_no from store_b_customer_tran where tran_type_cd = 'Y'

select id from t group by id having sum(case when keyword = 'ISV' then 0 else 1 end) = 0

Standard SQL does not (currently) allow select *,expressions ... from t ... use select t.*,expressions ... from t ...

Use of ` is not ANSI SQL compliant. @lastID:=LAST_INSERT_ID() is not ANSI SQL compliant. @ is not a valid character in an identifier. LAST_INSERT_ID is a Mysql specific routine. ; is only used as delimiter between statements, not as a terminator.

If you have the data dateColumn | rateColumn ------------------ 2006-04-23 | 1234 2006-04-23 | 5678 what result do you want? It is not clear from your post.

select column2, count(*) from t group by column2

You must specify the maximum length for the varchar columns.

SELECT SUM(pointsrecvd),userid FROM tblPointSystem group by userid order by 1 desc 1 reflects the position in the select list of the item you wish to order by.

SELECT SUM(pointsrecvd),userid FROM tblPointSystem group by userid

SELECT group_id FROM group g left join usergroup ug on ug.group_id = g.group_id and ug.user_id = 3 where ug.group_id is null