How to find the middle number in sql server query?

Jenith Thakkar8y ago

Accepted answer

DECLARE @m INT

Declare @newid INT

select @m = COUNT(*) from number

if (@m-1)%2=0

begin

set @newid=((@m-1)/2)+1

select no from number where id=@newid

end

else

begin

select 0;

end

Jenith Thakkar8y ago

Please Accept The Answer if it's helpful for you

Debasis Mohapatra8y ago

Thank you

Debasis Mohapatra8y ago

Hi,

I have try as per the below query, but it's not working i have cross check ROWNUM and ROW_NUMBER in sql server 2014 . my table name is number , there are two column id and no. Could you please check my below query.

Msg 156, Level 15, State 1, Line 38

Incorrect syntax near the keyword 'WHERE'.

Msg 189, Level 15, State 1, Line 38

The round function requires 2 to 3 arguments.

SELECT *

FROM (SELECT e.*,

ROW_NUMBER no

FROM number e)

WHERE no = (SELECT ROUND(Count(*) / 2)

FROM number)

Nanddeep Nachan8y ago

Please try below query

SELECT *
FROM (SELECT e.*,
ROWNUM rnum
FROM table e)
WHERE rnum = (SELECT ROUND(Count(*) / 2)
FROM table);