3 ms·
Got it. I agree. The "where exists (select 1...)" thing was neat. Learned me something.
by angilly 16y ago
Got it. I agree. The "where exists (select 1...)" thing was neat. Learned me something.
- nerfhammer 16y agoI believe that select * is actually conventional for an exists subquery
- ergo98 16y agoI have a natural aversion to "SELECT *" (it is almost always a bad usage), so while any decent database system will parse it to yield the same query plan, I still use SELECT 1.