Search results for query: *

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

SELECT tbl1.id, name, t2.color FROM tbl1 left join tbl2 t2 on tbl1.id = t2.t1_id left join tbl2 t3 on t2.t1_id = t3.t1_id and t3.color = 'green' where t3.color is null time to upgrade ...

SELECT tbl1.id, name, color FROM tbl1 left join tbl2 on tbl1.id = tbl2.t1_id where not exists (select * from tbl2 where tbl1.id = tbl2.id and color = 'green')

select * from venda where cast(integerColumn as varchar(20)) like '%'+xxxxx+'%'

The where clause is not in the wrong place. I typed the conditions incorrectly but it is located where I intended it to be. Note the use of a derived table.

select LastName, FirstName, case when min(credentials.fk) is null then 'No' else 'Yes' end as credentaials from demographics left join credentials on demographics.pk = credentials.fk group by lastName,FirstName