Hello everyone I have one query regarding to sql.

Sourabh Dhiman

1y765SQL

select salary from dbo.Employee where 1==1 . -- What will this query return?

3 Replies

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

Jignesh Kumar1y ago
Accepted answer
Hello Sourabh,

First of all == will not work,

In standard SQL, the equality operator is = (not ==). The query you wrote might not execute if the SQL dialect you're using does not support == for equality checks. The correct syntax would be:
```
SELECT salary 
FROM dbo.Employee 
WHERE 1 = 1;
```
The WHERE 1 = 1 condition always evaluates to TRUE, meaning it applies no filtering to the data.

As a result, every row in the table satisfies the condition and is included in the result.
+2
Sourabh Dhiman1y ago
Thanks, Jignesh. This is my fault. I wrote == in the query
0
Naimish Makwana1y ago
The query SELECT salary FROM dbo.Employee WHERE 1=1; will return the salary column for all rows in the Employee table. The condition 1=1 is always true, so it doesn't filter out any rows. Essentially, this query retrieves the salary information for every employee in the table.

Thanks
+3