Re: alias a select query

2003-03-09 Thread Paul DuBois
At 23:52 +0800 3/9/03, Hu Qinan wrote: Dear all, A table "book" looks like this: "page" "content" -- 1 abc 1 de 2 fgh 3 ijk 3 lmn 3 opq ... 210 z I need a query to randomly select 90% of all pages and their corresponding contents. I have writte

alias a select query

2003-03-09 Thread Hu Qinan
Dear all, A table "book" looks like this: "page" "content" -- 1 abc 1 de 2 fgh 3 ijk 3 lmn 3 opq ... 210 z I need a query to randomly select 90% of all pages and their corresponding contents. I have written the following querys. But I have pr