I want to know the difference between SELECT 1 and 0

Asked 2 years ago, Updated 2 years ago, 41 views

Usually when checking the low count of a table

I use SELECT 1, 0 (FROM DUAL) a lot, but is there a difference between 0 and 1?

I don't think there's much difference in speed, but I'm just curious if it's your preference.

database

2022-09-22 13:49

1 Answers

I understand that there is no difference. If I check the execution plan, it will be the same.


2022-09-22 13:49

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.