How many rows may be retrieved by the select statement in the following SQL code samples?

 create table t1  (k int unique)
               insert t1 values (rand()*1000)
               insert t1 values (rand()*1000)
               insert t1 values (rand()*1000)
               [...1000 additional inserts...]
               select * from t1 where k = rand()*1000
Ans: 0 or 1

No comments: