Revolving around the core of technology
Does WinSQL support median funtion?
I have been trying select median(price) from sales_table and I keep getting the following error:
There is no message text corresponding to SQL error "-4742" in the message file on this workstation. The error was returned from module "DSNXORFN" with original tokens "2".
Thanks!
Which database are you connecting to? WinSQL inherits the SQL grammar from the back-end database; it does not have any syntax of its own. Therefore, I recommend you refer to the documentation of your back-end database to see if this function is supported.