Removing Top 5% of Records

Question

I have the following code and I would like to remove the top 5% of the records for the Triage_To_Dr_Sees_Adjust numeric variable. Is this possible(I know using Select TOP(95) Percent would give me the top 95% but I want reverse of that, I would like the bottom 95%)?. Thank you!

UPDATE: I included code from an answer below, now my issue is that this code produces no records.

use EMTCQIData

DECLARE @StartDate Date
DECLARE @EndDate Date

Set @StartDate = '05/01/2017'
Set @EndDate = '12/31/2018'


SELECT sub.*
    FROM (
    Select *,
    Format([CHECKIN_DATE_TIME],'dddd') AS Checkin_Day,  
    CONVERT(VARCHAR(10),[CHECKIN_DATE_TIME],111) as Checkin_date, 
    CONVERT(VARCHAR(20),[CHECKIN_DATE_TIME],108) as Checkin_Time, 
    Case when TRIAGE_TO_DR_SEES < 0 then 0 else TRIAGE_TO_DR_SEES end as 
    TRIAGE_TO_DR_SEES_ADJUST 
    FROM ED_TAT_MASTER
    WHERE 
    (CHECKIN_DATE_TIME > @StartDate and CHECKIN_DATE_TIME < @EndDate) 
    AND (TRIAGE_DATE_TIME not like '')
    AND (TRIAGE_TO_DR_SEES not like '%no%')
    AND (TRACK_GROUP='ED Tracking Group') 
    AND (FORMAT([CHECKIN_DATE_TIME], 'dddd') = 'Sunday') 
    AND CHECKIN_DATE_TIME not like '%2017-07-02%' 
    AND CHECKIN_DATE_TIME not like '%2017-12-24%'
    AND CHECKIN_DATE_TIME not like '%2018-06-10%'
) sub

WHERE sub.TRIAGE_TO_DR_SEES not in (select top(5) Percent sub.TRIAGE_TO_DR_SEES
FROM ED_TAT_MASTER
ORDER BY CHECKIN_DATE_TIME)

Answer 1

This gets the top 5 percent in a subquery, then gets everything else in the main query. So add your logic for the 5% in the subquery, then the outer query will get you everything else.

SELECT *
FROM TableName
WHERE TableIdentity NOT IN (
    SELECT TOP (5) PERCENT TableIdentity
    FROM TableName
    ORDER BY TableIdentity (OR whatever logic you want)
)

Answer 2

As mentioned in the comments, the "last" 95 percent is just the "first" 95 percent the other way, so just reverse your ORDER BY. If the "final" order of your data is that important, then you can wrap it in a subquery:

--Generate some sample data (numbers 1 to 1000)
WITH N AS (
    SELECT N
    FROM (VALUES(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL))V(N)),
Tally AS(
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS I
    FROM N N1
         CROSS JOIN N N2
         CROSS JOIN N N3)
--The solution
SELECT I
FROM (SELECT TOP (95) PERCENT I
      FROM Tally
      ORDER BY I DESC) T
ORDER BY I ASC;

This returns the numbers 51-1000 in numerical order, aka the "last" 95%.

So, for your query, in Pseudo-SQL, it'll be:

SELECT {YourColumns}
FROM (SELECT TOP (95) PERCENT
             {YourColumns},
             CHECKIN_DATE_TIME
      FROM ED_TAT_MASTER
      WHERE ...
      ORDER BY CHECKIN_DATE_TIME DESC --The reverse of the order you want
      ) AS T
ORDER BY CHECKIN_DATE_TIME ASC;