窗函数 (SQL)

Window function - kind of function in SQL; calculations across a set of table rows that are somehow related to the current row. Article "窗函数 (SQL)" in Chinese Wikipedia has 29.2 points for quality (as of July 1, 2025). The article contains 13 references and 7 sections.

This article has the best quality in English Wikipedia. Also, this article is the most popular in that language version.

Since the creation of article "窗函数 (SQL)", its content was written by 1 registered users of Chinese Wikipedia and edited by 38 registered Wikipedia users in all languages.

The article is cited 14 times in Chinese Wikipedia and cited 107 times in all languages.

The highest Authors Interest rank from 2001:

• Local (Chinese): #116818 in October 2022
• Global: #201540 in September 2017

The highest popularity rank from 2008:

• Local (Chinese): #228092 in March 2024
• Global: #273418 in March 2015

There are 6 language versions for this article in the WikiRank database (of the considered 55 Wikipedia language editions).

The quality and popularity assessment was based on Wikipédia dumps from July 1, 2025 (including revision history and pageviews for previous years).

The table below shows the language versions of the article with the highest quality.

#	Language	Quality grade	Quality score
1	English (en) Window function (SQL)		33.5694
2	German (de) Fensterfunktion (SQL)		29.6044
3	Chinese (zh) 窗函数 (SQL)		29.1791
4	French (fr) Fonction de fenêtrage (SQL)		27.8055
5	Persian (fa) تابع پنجره (اس‌کیوال)		19.7375
6	Japanese (ja) 窓関数 (SQL)		0.9318

More...

The following table shows the most popular language versions of the article.

The most popular language versions of the article "窗函数 (SQL)" in all the time

#	Language	Popularity award	Relative popularity
1	English (en) Window function (SQL)		250 092
2	Japanese (ja) 窓関数 (SQL)		34 195
3	German (de) Fensterfunktion (SQL)		4 338
4	Chinese (zh) 窗函数 (SQL)		3 534
5	Persian (fa) تابع پنجره (اس‌کیوال)		325
6	French (fr) Fonction de fenêtrage (SQL)		136

More...

The following table shows the language versions of the article with the highest popularity in the last month.

The most popular language versions of the article "窗函数 (SQL)" in June 2025

#	Language	Popularity award	Relative popularity
1	English (en) Window function (SQL)		1 515
2	Chinese (zh) 窗函数 (SQL)		95
3	German (de) Fensterfunktion (SQL)		73
4	Japanese (ja) 窓関数 (SQL)		66
5	French (fr) Fonction de fenêtrage (SQL)		52
6	Persian (fa) تابع پنجره (اس‌کیوال)		6

More...

The following table shows the language versions of the article with the highest Authors’ Interest.

Language versions of the article "窗函数 (SQL)" with the highest Authors Interest (number of authors). Only registered Wikipedia users were taken into account.

#	Language	AI award	Relative AI
1	English (en) Window function (SQL)		24
2	German (de) Fensterfunktion (SQL)		6
3	Japanese (ja) 窓関数 (SQL)		4
4	Persian (fa) تابع پنجره (اس‌کیوال)		2
5	French (fr) Fonction de fenêtrage (SQL)		1
6	Chinese (zh) 窗函数 (SQL)		1

More...

The following table shows the language versions of the article with the highest Authors’ Interest in the last month.

Language versions of the article "窗函数 (SQL)" with the highest AI in June 2025

#	Language	AI award	Relative AI
1	German (de) Fensterfunktion (SQL)		0
2	English (en) Window function (SQL)		0
3	Persian (fa) تابع پنجره (اس‌کیوال)		0
4	French (fr) Fonction de fenêtrage (SQL)		0
5	Japanese (ja) 窓関数 (SQL)		0
6	Chinese (zh) 窗函数 (SQL)		0

More...

The following table shows the language versions of the article with the highest number of citations.

Language versions of the article "窗函数 (SQL)" with the highest Citation Index (CI)

#	Language	CI award	Relative CI
1	English (en) Window function (SQL)		48
2	French (fr) Fonction de fenêtrage (SQL)		37
3	Chinese (zh) 窗函数 (SQL)		14
4	Japanese (ja) 窓関数 (SQL)		6
5	Persian (fa) تابع پنجره (اس‌کیوال)		2
6	German (de) Fensterfunktion (SQL)		0

More...

#	Language	Value
de	German Fensterfunktion (SQL)
en	English Window function (SQL)
fa	Persian تابع پنجره (اس‌کیوال)
fr	French Fonction de fenêtrage (SQL)
ja	Japanese 窓関数 (SQL)
zh	Chinese 窗函数 (SQL)

Best Rank

Chinese: #228092 03.2024

Global: #273418 03.2015

Best Rank

Chinese: #116818 10.2022

Global: #201540 09.2017

On 12 August 2025 in multilingual Wikipedia, Internet users most often read articles on the following topics: Cristiano Ronaldo, Wednesday, Georgina Rodríguez, ChatGPT, Weapons, Jenna Ortega, deaths in 2025, Taylor Swift, Miguel Uribe Turbay, 2025–26 UEFA Champions League.

In Chinese Wikipedia the most popular articles on that day were: 朱由𣜬, 林岱樺, 林逸欣, 江油未成年人欺凌事件, 鬼滅之刃, 黃士修, 鬼滅之刃角色列表, 锦月如歌, 2025年亞洲盃籃球賽, 鬼滅之刃劇場版 無限城篇.

The WikiRank project is intended for automatic relative evaluation of the articles in the various language versions of Wikipedia. At the moment the service allows to compare over 44 million Wikipedia articles in 55 languages. Quality scores of articles are based on Wikipedia dumps from July, 2025. When calculating current popularity and AI of articles data from June 2025 was taken into account. For historical values of popularity and AI WikiRank used data from 2001 to 2025... More information