数据如下:
id name province
2001 li hlj
2003 liu hlj
2004 jian ln
2005 li ln
2006 li ln
2007 luy hlj
2008 liu hlj
2002 luy hlj结果no id name province
1 2001 li hlj
2 2002 luy hlj
3 2003 liu hlj
4 2007 luy hlj
5 2008 liu hlj
1 2004 jian ln
2 2005 li ln
3 2006 li ln在Oracle 如何求解?
条件是按照province分组求行NO?
求解?
id name province
2001 li hlj
2003 liu hlj
2004 jian ln
2005 li ln
2006 li ln
2007 luy hlj
2008 liu hlj
2002 luy hlj结果no id name province
1 2001 li hlj
2 2002 luy hlj
3 2003 liu hlj
4 2007 luy hlj
5 2008 liu hlj
1 2004 jian ln
2 2005 li ln
3 2006 li ln在Oracle 如何求解?
条件是按照province分组求行NO?
求解?
解决方案 »
- |zyciis| 服务器报错:SHUTDOWN is in progress Login failed for user 'bill'. Only admini
- 谁给解释下
- SQL2005连接问题
- SQL 2000数据库还原时的问题
- t1.f1=t2.f1与t1.f1=* t2.f1有何不同
- 文本數據如何導進 SQL SERVER
- 大力,請賜教........
- 一个怪怪的问题???
- 两台win98的机器,一台上装有sql server7.0桌面版,如何在另一台机器上连接它?
- 按照月份统计优质投资人的10分钟报障响应率
- 关于SQL 2000和2005备份问题探讨
- mssql 中如何获取某个表的列的相关信息(列名、类型、长度)?
--SQL 2005select *,no=row_number() over (partition by province order by getdate())
from tb
select ROWID as no, * from ta
insert into tb select '2001','li','hlj'
insert into tb select '2003','liu','hlj'
insert into tb select '2004','jian','ln'
insert into tb select '2005','li','ln'
insert into tb select '2006','li','ln'
insert into tb select '2007','luy','hlj'
insert into tb select '2008','liu','hlj'
insert into tb select '2002','luy','hlj'
go
select row_number()over(partition by province order by id)no,* from tb
go
drop table tb
/*
no id name province
-------------------- ---------- ---------- ----------
1 2001 li hlj
2 2002 luy hlj
3 2003 liu hlj
4 2007 luy hlj
5 2008 liu hlj
1 2004 jian ln
2 2005 li ln
3 2006 li ln(8 行受影响)*/
select row_number() over (partition by province order rownum) as No,id ,name ,province
from table_name