Percentile Function in Tidb
Open
compatibility-oracle
good first issue
sig/execution
type/compatibility
type/feature-request
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Bug Report
perncentile on a column is not working
SELECT
PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY column_name) OVER () AS Q3
FROM
YourTable;
This is the query which is supported in both postgresql and mysql but it is throwing an error in TIDB
### 2. What did you expect to see? (Required)
result
### 3. What did you see instead (Required)
You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 2 column 41 near "(ORDER BY `_org_unit_id`) OVER () AS Q1
### 4. What is your TiDB version? (Required)
7.3.0
Contributor guide
Assessment
This issue has not been assessed yet.