DECLARE @table TABLE(id int, name varchar(100))
INSERT INTO @table
SELECT 1, 'Patient Information' union all
SELECT 2, 'Patient Demographics' union all
SELECT 3, 'Languages' union all
SELECT 4, 'Race' union all 
SELECT 5, 'Ethnicity' union all 
SELECT 6, 'City' union all 
SELECT 7, 'State' union all
SELECT 8, 'Zip Codes' union all
SELECT 9, 'Billing Encounter'

SELECT * 
FROM @table
ORDER BY CASE when id = 8 THEN 1 ELSE 2 END

quote:

---

Originally posted by mohan123

hello all,

I had a table of 10 record for my users table.Now My problem is i have record in 8th row that record i need to show as first record
like user table

1 Patient Information Patient Information 1 H
2 Patient Demographics Patient Demographics 1 P
3 Languages Languages 1 P
4 Race Race 1 P
5 Ethnicity Ethnicity 1 P
6 City City 1 P
7 State State 1 P
8 Zip Codes Zip Codes 1 P
9 Billing Encounter Billing Encounter 1 H

in that one 8th record i need to move as first record

i wrote query like this

select * from users where userId = 8

union

select * from users where userid != 8..

It shows exact output but how need to 8th record first place permanently

P.V.P.MOhan

---