Display order of a SQL Query without order by clause

Question

I am writing a simple query in SQL Server:

Select 
    EmpId, EmpName, Sal 
from 
    Emp 
where  
    EmpId in (10,9,5,7,3,8);

I want to get the output in a same order which is given i.e; 10,9,5,7,3,8

Actually whatever I'll give the result will display with given order without order by ascending or descending.

How can I do that? Please help.

Answer 1

No way to do this natively. Try:

SELECT EmpId,EmpName,Sal
FROM Emp
WHERE EmpId IN (10,9,5,7,3,8)
ORDER BY CASE EmpId
    WHEN 10 THEN 1
    WHEN 9 THEN 2
    WHEN 5 THEN 3
    WHEN 7 THEN 4
    WHEN 3 THEN 5
    WHEN 8 THEN 6
    ELSE 7
END;

Answer 2

You can use a table variable to pass the inputs. You must insert the records into this table variable in the desired order.

Declare @empids table(id int identity(1,1),empid int)
insert into @empids values(10),(9),(5),(7),(3),(8)

Select e.EmpId,e.empname,e.sal from Emp e
join @empids t on  e.EmpId = t.empid 
order by t.id

Try this.