表内容如下:
name | seqno | description
A | 1 | test
A | 2 | test
A | 3 | test
A | 4 | test
A | 5 | test
A | 6 | test
A | 7 | test
B | 1 | test
B | 2 | test
B | 3 | test
B | 4 | test
B | 5 | test
B | 6 | test
B | 7 | test
C | 1 | test
C | 2 | test
C | 3 | test
C | 4 | test
C | 5 | test
C | 6 | test
C | 7 | test
我想有一个sql语句,搜索的结果是
A | 1 | test
A | 2 | test
A | 3 | test
B | 1 | test
B | 2 | test
B | 3 | test
C | 1 | test
C | 2 | test
C | 3 | test
请问该怎么实现?
name | seqno | description
A | 1 | test
A | 2 | test
A | 3 | test
A | 4 | test
A | 5 | test
A | 6 | test
A | 7 | test
B | 1 | test
B | 2 | test
B | 3 | test
B | 4 | test
B | 5 | test
B | 6 | test
B | 7 | test
C | 1 | test
C | 2 | test
C | 3 | test
C | 4 | test
C | 5 | test
C | 6 | test
C | 7 | test
我想有一个sql语句,搜索的结果是
A | 1 | test
A | 2 | test
A | 3 | test
B | 1 | test
B | 2 | test
B | 3 | test
C | 1 | test
C | 2 | test
C | 3 | test
请问该怎么实现?
select * from AAA where seqno in ('1','2','3')
select * from tablename where seqno between 1 and n
order by name,seqno(n=1,2,3,.....,n)
select * from tab
where seqno between &m and &n
order by name,seqno
你运行时就会提示你输入参数,然后就可以找到你想要得 m 到 n 的数据。
select name,seqno,description
from(select name,seqno,description,row_number()over(partition by name order by seqno)id
from table_name) where id<=3;