I have two requirements here with my select query ( see attach code)
I wanting to have 2.5 % of records. I want random records and not the TOP records. how could i get this?
Second requirement. if you see my where clause i have disposition in (RNR,ptp,nb,cb) now I want this in priority.
it should check if it got RNR records if not then it should check for PTP and then NB .. so on.
how could I set the priorty search?
Any suggestions are highly appreciated.
select top 2.5 percent * from [table_name]
where status='negative' and deli_day='30' and
[disposition] in ('RNR','PTP','NB','CB')