iamhucong opened a new issue, #28387:
URL: https://github.com/apache/shardingsphere/issues/28387
- [ ] create sequence LAB_SAMPLES_SEQ
- [ ] insert into moons values ('','',)
- [ ] create or replace view named_moons as select p.name planet, p.class,
m.name moon, m.radius from planets p, moons m where p.name = m.planet_name(+)
and m.name(+) not like 'S/%'
- [ ] create or replace function LAST_CLOSE(p_close_date date) return number
is begin return case to_char(p_close_date,'DY') when 'SUN' then 2 when 'MON'
then 3 else 1 end
- [ ] select owner, approx_count(*) , approx_rank(partition by owner order
by approx_count(*) desc) from t group by owner having approx_rank(partition by
owner order by approx_count(*) desc) <= 1 order by 1
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
