Bonjour à tous !
petite explication de ce que j'essaie de faire :
Code:
1
2
3
4
5
6
| select
row_number() over (partition by t.time order by t.time asc) as num,
price
from tmp_intraday_bb t
where condition_code is null
and ticker ='FTE FP Equity' |
Citation:
1 19.31
2 19.325
3 19.32
4 19.32
5 19.32
6 19.325
7 19.325
maintenant je veux la ligne avec un numéro à 1
Code:
select * from #test
Citation:
1 19.31
2 19.325
3 19.32
4 19.32
5 19.32
6 19.325
7 19.325
mais si je fais :
Code:
select * from #test where num = 1
Citation:
1 19.31
1 19.325
1 19.32
1 19.32
1 19.32
1 19.325
1 19.325
J'ai essayé aussi ça :
Code:
1
2
3
4
5
6
7
8
9
10
| select *
from (
select
row_number() over (partition by t.time order by t.time asc) as num,
price
from tmp_intraday_bb t
where condition_code is null
and ticker ='FTE FP Equity'
) t
where num = 1 |
mais j'obtiens toujours
Citation:
1 19.31
1 19.325
1 19.32
1 19.32
1 19.32
1 19.325
1 19.325
Avec le CTE j'ai le même problème
Code:
1
2
3
4
5
6
7
8
9
10
| WITH CTE as
(
select
row_number() over (partition by t.time order by t.time asc) as num,
price
from tmp_intraday_bb t
where condition_code is null
and ticker ='FTE FP Equity'
)
select * from CTE where num = 1 |
et résultat :
Citation:
1 19.31
1 19.325
1 19.32
1 19.32
1 19.32
1 19.325
1 19.325
Ce qui est franchement n'importe quoi.
si je fais
Code:
1
2
3
4
5
6
7
8
9
10
| WITH CTE as
(
select
row_number() over (partition by t.time, order by t.time asc) as num,
price
from tmp_intraday_bb t
where condition_code is null
and ticker ='FTE FP Equity'
)
select * from CTE where num between 1 and 3 |
Citation:
1 19.31
2 19.325
3 19.32
1 19.33
2 19.33
3 19.335
1 19.4
Savez-vous pourquoi il me fait ça ?
Merci !
