如何以降序显示标识列值？ [英] How to display Identity column value in Descending order?

问题描述

在我的表中，我有一栏，即

SNo。它是主键和标识列，应按降序显示SNo。

请帮我查询格式

解决方案

< pre lang =SQL> 选择 SNo 来自 表 订单 按 SNo Desc

  SELECT  *  FROM  MyTable  ORDER   BY  SNo  DESC  

谷歌有很多ex。

试试这个，

< pre lang =SQL> 选择 * 来自 Your_table_name 订单 SNo desc

In my Table i have one column ,i.e.
SNo. it is primary key and identity column and should Display SNo in Descending order.
pls help me in the way of Query Format

解决方案

select SNo from Table order by SNo Desc

SELECT * FROM MyTable ORDER BY SNo DESC

There are so many ex available in Google.
Try this,

select * from Your_table_name order by SNo desc

这篇关于如何以降序显示标识列值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！