Sql 10% data only.. [message #329643] |
Thu, 26 June 2008 02:28  |
tannad
Messages: 43 Registered: January 2008 Location: mumbai
|
Member |
|
|
I have one table with 6 millons of data
But for checking I want the data suppose only 10% of the records.
supose I run this query
select * from VA_FINAL_2JUNE
where DATA_SOURCE in('PO','1358_Misc_Obligation','Pcard','NPPD','High_Tech_Medical_equipment')
and TOTALCOST >100000
I will get all the records.. But I want only 10 or 12 % of the data
what change I will do in the query?
|
|
|
|
|
|
|
|
|