What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-05 03:54:02
find the median in sql
# FOR TABLES WITH EVEN NUMBER OF ROWS # For column1 in table1 with 'n' number of rows. Where 'n' is an even number. # 1. Change all column1 and table1 to your column and table name. # 2. Calculate (n/2)+1, where n=number of rows, and set it as LIMIT for ... Add solution