如何按降序对数据进行排序 [英] How to sort data in descending order

问题描述

我创建了以下存储过程，按查询日期的降序对数据进行排序，但数据没有排序...

请帮帮我...提前致谢

I have created below stored procedure to sort data in descending order of enquiry date but the data isn't getting sorted...
Please help me... Thanks in advance

ALTER Procedure [GetEnquiriesForPurchase]
	@PageIndex INT = 1
	,@PageSize INT = 10
	,@RecordCount INT OUTPUT
	--,@IsProcess int
	,@EmpId int=null
as
Begin
	SET NOCOUNT ON;
	SELECT distinct(Enq.EnquiryId) ,
		--ROW_NUMBER() OVER
		DENSE_RANK() OVER
		(
			--PARTITION BY Enq.EnquiryId 
			ORDER BY Enq.EnquiryDate DESC
		)AS RowNumber,
		Enq.enquirydate, emp.FirstName +' '+emp.LastName as EmployeeName
		,emp.Emailid
		,Enq.[Status]
		,Enq.[ActionRequiredBy]
		, Cust.Name
		,Cust.Designation 
		,Enq.Isprocess
		--,PEND.PurchasePersonId
		--,emp.FirstName +' '+emp.LastName as PurchaseHandler
	INTO #Results 
	from Enquiries Enq 
	inner join employees emp on Enq.SalesPersonId=emp.Id 
	--inner join PurchaseEnquiryNewDetails PEND on PEND.PurchasePersonId =emp.Id and PEND.enquiryId=Enq.enquiryId
	inner join Enquirydetails enqdet on enqdet.EnquiryId=enq.EnquiryId
	inner join Customers cust on Enq.CustomerId=Cust.Id and enqdet.manufactureCode in ( select mfg.manufactureCode from manufacturers mfg
			inner join aspnet_Roles asr on asr.RoleName=mfg.Name
			inner join aspnet_UsersInRoles aur on aur.RoleId= asr.RoleId
			inner join employees emp1 on emp1.loginid= aur.UserId and emp1.Id=@EmpId)
	ORDER BY Enq.EnquiryDate DESC

	SELECT @RecordCount = COUNT(*)
	FROM #Results

	SELECT * FROM #Results
	WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

	DROP TABLE #Results
End 

推荐答案

要在SQL中对数据进行排序，请在最终查询中使用 ORDER BY enquirydate DESC

To sort data in SQL use ORDER BY enquirydate DESC on your final query

你可以写下你的查询如......

Your can write your query like......

Select * from Enquiries ORDER BY enquirydate DESC

这篇关于如何按降序对数据进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！