DELETE FROM emp
WHERE key = '123'
AND (name IS NULL OR name = 'abc');
assuming "available" means "is not null ...
>-----Original Message-----
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>boun...@sqlite.org] On Behalf Of d b
>Sent: Monday, 18 November, 2013 00:46
>To: sqlite-users@sqlite.org
>Subject: [sqlite] query optimization
>
>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
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
