Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Support of Window Functions in MariaDB

sderom's profile image sderom posted 2 weeks ago in General Permalink

Window functions were introduced in MariaDB 10.2.0. Does HeidiSQL support window functions such as ROW_NUMBER, RANK, DENSE_RANK, PERCENT_RANK, CUME_DIST, NTILE, COUNT, SUM, AVG, BIT_OR, BIT_AND and BIT_XOR?

ansgar's profile image ansgar posted 2 weeks ago Permalink

Some of these are listed in the context sub menu "Insert function":

Description

In what way would you expect support for these functions, apart from the fact that you can use them in your queries?

ansgar's profile image ansgar posted 2 weeks ago Permalink

By the way, these listings just got a tooltip with their help text in the next build:

Description

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
sderom's profile image sderom posted 2 weeks ago Permalink

So when I don't find the function (like ROW_NUMBER, RANK, DENSE_RANK, PERCENT_RANK, CUME_DIST, NTILE), it means HeidiSQL doesn't support it?

PS: the help text is really great !

ansgar's profile image ansgar posted 2 weeks ago Permalink

What do you mean with "I don't find the function"? I suppose you just can't find it in the SQL proposal:

Description

But that just means that function list should get another update. You can still fire such queries.

Please login to leave a reply, or register at first.