在sql查询中重新执行序列号 [英] reteriving Serial number in sql query

问题描述

  SELECT  row_number（） Over （订单   dbo_M_City.CityID）  [Sno]，dbo_M_City。 CityID，dbo_M_City.CityName 
  FROM  dbo_M_City; 

i需要获取使用此查询的序列号，但它在查询表达式''row_number（）中显示错误

语法错误（缺少运算符）（按dbo_M_City.CityID排序）< br $>




任何人都可以帮助

解决方案

一些语法问题，无需指定tablename.Column名称的每一个。

  SELECT  row_number（）结束（订单  by  CityID） as  [Sno]，CityID，CityName 
  FROM  dbo.M_City 

检查以下链接，您将获得Clear Idea abount ROW_Number（）函数。

如何使用ROW_NUMBER（）枚举和分区SQL Server中的记录 [ ^ ]

ROW_NUMBER（Transact-SQL） [ ^ ]



问候，

GVPrabu

  SELECT  ROW_NUMBER（） OVER （ ORDER   BY  CITYID） as  [SNO]，
 CITYID，
 CITYNAME 
  FROM  dbo.M_CITY; 

在这里，我尝试在本地复制你的问题，这解决了这个问题。

SELECT row_number() Over (Order by dbo_M_City.CityID) as [Sno],dbo_M_City.CityID, dbo_M_City.CityName
FROM dbo_M_City;

i need to get serial number used this query but it shows error
syntax error (missing operator) in query expression ''row_number() over (order by dbo_M_City.CityID)


Can any one help

解决方案

Hi,

Some syntax problem, No need to specify every where tablename.Column name.

SELECT row_number() Over (Order by CityID) as [Sno],CityID, CityName
FROM dbo.M_City

Check the following link, You will get Clear Idea abount ROW_Number() Function.
How to use ROW_NUMBER() to enumerate and partition records in SQL Server[^]
ROW_NUMBER (Transact-SQL)[^]

Regards,
GVPrabu

SELECT ROW_NUMBER() OVER (ORDER BY CITYID) as [SNO],
CITYID,
CITYNAME
FROM dbo.M_CITY;

Here, I tried replicating your issue locally and this solved the problem.

这篇关于在sql查询中重新执行序列号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！