Difference between revisions of "DblpConfSeriesQuery"
Jump to navigation
Jump to search
(pushed from test by wikipush) |
(pushed from test by wikipush) |
||
| Line 6: | Line 6: | ||
|author=Wolfgang Fahl | |author=Wolfgang Fahl | ||
|since=2021/01/31 | |since=2021/01/31 | ||
| − | |text=select conf,count(*) as count,min(year) as minYear,max(year) as maxYear | + | |text=select conf,title,count(*) as count,min(year) as minYear,max(year) as maxYear |
from proceedings | from proceedings | ||
where conf is not null | where conf is not null | ||
Latest revision as of 13:15, 4 February 2021
Sourcecode
| Sourcecode | |
|---|---|
| id | DblpConfSeriesQuery |
| lang | sql |
| author | Wolfgang Fahl |
| since | 2021/01/31 |
| test | select conf,title,count(*) as count,min(year) as minYear,max(year) as maxYear
from proceedings
where conf is not null
group by conf
order by 2 desc
|
| url | |