Debasis Mohapatra

Debasis Mohapatra

  • NA
  • 381
  • 56.7k

How to find the middle number in sql server query?

Jul 31 2018 2:20 AM
I have a Table in my Sqlserver database . Id(PK),No Column, In Number column i have 5 records ,1,2,3,4,5, i want to display only 3 through sql query.
 
CREATE TABLE [dbo].[number](
[id] [int] IDENTITY(1,1) NOT NULL,
[no] [int] NULL
) ON [PRIMARY]
GO

Answers (5)