5
Answers

How to find the middle number in sql server query?

Debasis Mohapatra

Debasis Mohapatra
6y
2.5k
1
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)
Next Recommended Forum