[DiscordArchive] <@787614711738138634> How did you get that graph site to have different steps on x and y?
[DiscordArchive] <@787614711738138634> How did you get that graph site to have different steps on x and y?
Original source
<@787614711738138634> How did you get that graph site to have different steps on x and y?
rektbyfaith
06-02-2022, 02:28 PM #1Archived author: ACHERAX • Posted: 2022-06-02T14:28:05.355000+00:00
Original source
<@787614711738138634> How did you get that graph site to have different steps on x and y?
Original source
![[Image: unknown.png?ex=690c07e0&is=690ab660&hm=3...8569daa29&]](https://cdn.discordapp.com/attachments/415944535718494208/981927371353518202/unknown.png?ex=690c07e0&is=690ab660&hm=3710f1a31ac939e181a50d4ea2d60ed29d168eab2c262d69acc2ed78569daa29&)
rektbyfaith
06-02-2022, 02:28 PM #2Archived author: <o> • Posted: 2022-06-02T14:28:48.814000+00:00
Original source
Original source
Oh neat
rektbyfaith
06-02-2022, 02:29 PM #3Archived author: ACHERAX • Posted: 2022-06-02T14:29:55.940000+00:00
Original source
Oh neat
Original source
Thank you
rektbyfaith
06-02-2022, 02:29 PM #4Archived author: ACHERAX • Posted: 2022-06-02T14:29:58.757000+00:00
Original source
Thank you
Original source
Whenever anyone has a moment, I would appreciate some help trying to solve this issue.
I have this SQL script:
```sql
SELECT entry, itemLevel, COUNT(*)
FROM spell_value_table
GROUP BY entry, itemLevel;
```
Right now its sorts results by entry and ItemLevel into something like this:
```
Entry ItemLevel COUNT
88 11 1
88 22 1
88 30 4
91 18 2
```
Is there a way I can modify the script to only show results of the HIGHEST count from each group, for example from the scenario above, I want the script to show the following:
```
Entry ItemLevel COUNT
88 30 4
91 18 2
```
rektbyfaith
06-02-2022, 02:38 PM #5Archived author: Peacy • Posted: 2022-06-02T14:38:38.936000+00:00
Original source
Whenever anyone has a moment, I would appreciate some help trying to solve this issue.
I have this SQL script:
```sql
SELECT entry, itemLevel, COUNT(*)
FROM spell_value_table
GROUP BY entry, itemLevel;
```
Right now its sorts results by entry and ItemLevel into something like this:
```
Entry ItemLevel COUNT
88 11 1
88 22 1
88 30 4
91 18 2
```
Is there a way I can modify the script to only show results of the HIGHEST count from each group, for example from the scenario above, I want the script to show the following:
```
Entry ItemLevel COUNT
88 30 4
91 18 2
```
1 Guest(s)
1 Guest(s)