in Databases retagged by
221 views
1 vote
1 vote

in Databases retagged by
221 views

1 Answer

3 votes
3 votes
Best answer
The query selects those marks for which the number of marks less than it,is equal to the number of marks greater than it.

For example, consider marks as $1,2,3,4,5$ then this query will return $3$.

Another Example  $1,2,3,4,5,6,7,8,9,10,11$ will return $6$

So it will return the middle most value that is median.
selected by
by

1 comment

Thanks man 😊
1
1

Related questions

0 votes
0 votes
0 answers
1
priyansh_1705 asked in Databases Jun 8, 2023
178 views
priyansh_1705 asked in Databases Jun 8, 2023
178 views
0 votes
0 votes
2 answers
4
Dknights asked in Databases Dec 12, 2022
394 views
Dknights asked in Databases Dec 12, 2022
394 views