SQL Server: Return rows with Specific (Default) value at first position

gokuldas

SOLVED CLOSED ACTIVE ANSWERED
User: gokuldas
Posted: on Sep 05, 2023 12:29 AM
Forum: SQL Server
Answer: 1
Views: 647

return rows with a specific value 'Select all ' as first

Select distinct 'Select All'  from ExpenseTable as a
 UNION all  SELECT Distinct IncomeDetails from ExpenseTable AS  b
where IncomeDetails!='' order by (case WHEN a.IncomeDetails= 'Select ALL' THEN 1 ELSE 2 end)

i get error ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.

please solve

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Sep 05, 2023 12:51 AM
Modified: on Sep 05, 2023 12:52 AM
Report

Hi gokuldas,

Refer below sample query.

Database

I have made use of the following table Customers with the schema as follows.

I have already inserted few records in the table.

You can download the database table SQL by clicking the download link below.

Download SQL file

SQL

SELECT * FROM 
(
	SELECT 'Select All' AS [Name]
	UNION all  
	SELECT DISTINCT [Name]
	FROM Customers
) t
ORDER BY CASE WHEN [Name] = 'Select ALL' THEN 0 ELSE 1 END

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

SQL Server: Return rows with Specific (Default) value at first position

Company

Explore

Follow us

Contact Us