Assuming you are using parameters you may use something like:
DELETE FROM emp WHERE key=?1 AND CASE ?2 IS NULL THEN 1 ELSE name=?2;
BR
2013/11/18 d b <[email protected]>
> Hi,
>
>
> I am trying to make single query instead of below two queries. Can
> somebody help?
>
> 1. delete from emp where key = '123';
> 2. delete from emp where key = '123' and name = 'abc';
>
> if Key available, execute 1st query. if key and name available, execute 2nd
> query.
>
> Is it possible to write in single query?
>
> Regards,
> va
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
