Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Order by clause - excluding one value

Home
Forums

Order by clause - excluding one value

Sai Reddy

Sai Reddy

8yAsked Sep 21, 2018, 5:54 AM766

Hi,

I need to order the result with the following data. Where 678 record should be on top and remaining should be as order by condition.

Id

100

200

678

678

875

900

678

ORDER BY ID DESC

Result should be as follows

678

678

678

900

875

200

100

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

nageshkits d8y ago
Accepted answer
Hello Sai,

please check below script

Declare @ExcludeNo int=678
declare @temp table(id int)
insert into @temp values(100),(200),(678),(678),(875),(900),(678)
select * from @temp
order by
case
when id=@ExcludeNo then (select sum(id) from @temp) else id
end
desc
0
rajendra singh8y ago
Hi Sai,

try below query
select id,1 as rowNum from tbl_test1 where id=678
union all
select id,2 as rowNum from tbl_test1 where id not in (678) order by rowNum,id desc
0