如何在sql server 2008中按照排序显示产品？ [英] How to display product according to sorting in sql server 2008?

问题描述

你好，



如何在sql server 2008中根据不同的排序类型显示产品或记录？



低至高价格

最高价格

最受欢迎

最新



这些是分拣选项。



请帮助我。



先谢谢。



Ankit Agarwal

软件工程师

解决方案

从低到高价格

  SELECT  *  FROM  MyTable  ORDER   BY 价格

从高到低价格

  SELECT  *  FROM  MyTable  ORDER   BY 价格 DESC  

Be st热门

  SELECT  *  FROM  MyTable  ORDER   BY  OrderCount  DESC  

最新

  SELECT  *  FROM  MyTable  ORDER   BY  InsertDate  DESC  

你应该在sql中进行动态查询..



< pre lang =SQL> 声明 @ strQuery nvarchar （max）， @ ColumName varchar （ 250 ）， @ Order varchar （ 10 ）

select @ strQuery = ' SELECT * FROM MyTable ORDER BY' + @ ColumName + ' ' + @ Order
exec （ @ strQuery ）

now如果你想根据价格对数据进行排序而不是传递 @ColumName ='price'和 @Order ='asc'或'$'

 声明  @ strQuery   nvarchar （max）， @ ColumName   varchar （ 250 ）， @ Order   VARCHAR （ 10 ）
 
  set  @ strQuery = '  Price' 
  set  @ Order = '  ASC' 
 
  select  @ strQuery = '  SELECT * FROM MyTable ORDER BY' +  @ColumName  + ' ' +  @Order  
  exec （ @ strQuery ）

您需要首先与要排序的选项关联的列和数据（例如 price ，受欢迎程度和创建日期，然后按以下方式执行SQL命令： http://www.w3schools.com/sql/sql_orderby.asp [ ^ ]

Hello,

How to display products or records according to different type of sorting in sql server 2008?

Low To High Price
High To Low Price
Best Popular
Latest

These are sorting options.

Please help me.

Thanks in Advance.

Ankit Agarwal
Software Engineer

解决方案

Low To High Price

SELECT * FROM MyTable ORDER BY Price

High To Low Price

SELECT * FROM MyTable ORDER BY Price DESC

Best Popular

SELECT * FROM MyTable ORDER BY OrderCount DESC

Latest

SELECT * FROM MyTable ORDER BY InsertDate DESC

you should make dynamic query in sql..

declare @strQuery nvarchar(max),@ColumName varchar(250),@Order varchar(10)

select @strQuery='SELECT * FROM MyTable ORDER BY '+ @ColumName +' ' + @Order
exec (@strQuery)

now if you want to sort data according to price than pass @ColumName='price' and @Order='asc' or 'Desc'

declare @strQuery nvarchar(max),@ColumName varchar(250),@Order varchar(10)

set @strQuery=' Price'
set @Order=' ASC'

select @strQuery='SELECT * FROM MyTable ORDER BY '+ @ColumName +' ' + @Order
exec (@strQuery)

You need columns and data associated with the options you want to sort on first (like price, popularity and create date, then you do a SQL order by : http://www.w3schools.com/sql/sql_orderby.asp[^]

这篇关于如何在sql server 2008中按照排序显示产品？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！