thanks to post this code here.
i have one concern for this query
i have one Employee table and it contains 2500 records..
when i tried this example on that table with
select * from Employee tablesample(10 rows)
so it returns 34 rows
than again i tried to run same query at that time it returns 25 rows
i again tried for same query at that time it returns nothing..
can you tell me where i am wrong to fetch records from table
and one more thing which is noticeable that every time it returns rows in random manner like empid between 1500 to something and another time empid 1250 to some records
so plz explain me what is the core logic for this.