filter with yes ,no and all in postgres

user511

1^#

user511 Published in April 26, 2018, 1:44 pm

I have a table in Postgres like

id phone_number
1 null
2 444444444
3 null
4 48572444444
5 4822555555

and there is a filter like has_value.Filter contain 3 value 'Yes','No' and 'Select All'.I want to filter data on basis of this filter if 'yes' then shown all id and mobile number which have a mobile number. if 'no' it must show null mobile number.if 'All' then all record.

Sql Postgresql

• Can I concatenate multiple MySQL rows into one field?
• How can I SELECT rows with MAX(Column value), DISTINCT by another column in SQL?
• How to 'insert if not exists' in MySQL?
• SQL Server: How to Join to first row
• Drop all tables in PostgreSQL?
• What are the options for storing hierarchical data in a relational database?
• MySQL SELECT only not null values
• SQL select only rows with max value on a column
• How do I check if a column is empty or null in mysql
• postgres: upgrade a user to be a superuser?

Return

You need to login account before you can post.

filter with yes ,no and all in postgres

Related posts