Loading

select quer for fetch all record

select quer for fetch all record

lejo

2y754SQL

@Status int

from page i am passing id 0,1,2

Table data is saved as 0,1 and type is int

where condition if 0 is passed from page -data will get status=0

where condition if 1 is passed from page -data will get status=1

where condition if 2 is passed from page -data will get status=0,1 .how to get all record by passing 2 from page

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Abhishek Chadha2y ago
To achieve the desired behavior where passing 2 from the page retrieves records with status=0 or status=1, you can use a SQL query with conditional logic. Here's how you can implement it:
```
SELECT *
FROM your_table
WHERE 
    (your_column = 0 AND :id = 0) OR
    (your_column = 1 AND :id = 1) OR
    (:id = 2)
```
:id is the parameter passed from the page

This query structure allows you to handle each condition based on the value of :id. When :id is 2, it retrieves all records without any condition on your_column.