Sampling by Percentage

Analytics
Enthusiast

Sampling by Percentage

Dear who know,

Currently I had a query to take 1000 sample from a customer table like this:
------------------------------------
Select Cust_Id, Name, Age From Customer
Sample 1000
------------------------------------

What happen if I need to random sampling by percentage (let said 25%) from the customer table?

How to write the SQL?

Thanks! ^_^
1 REPLY
Enthusiast

Re: Sampling by Percentage

Select Cust_Id, Name, Age From Customer
Sample .25