PostgreSQL commands

SELECT Query:

select * from tm_rizvi where delflg = -1 and tel IS NOT NULL limit 20 offset 0
select tcode, delflg, tel, mobtel, kentel, kenmtel from tm_rizvi where tel like '0339908611' limit 30 offset 0

UPDATE Query:

UPDATE tm_rizvi SET tel = '0339908612' where tcode = 01001

Delete Query:

delete from tm_rizvi where tcode=2 and tel like '0339908611'