SQL primary key from an exception occurs, use database first met for 20 years-CodePudding

The CREATE TABLE [dbo] [dt_eduexamResultDetail] (
[id]/int IDENTITY (1, 1) NOT NULL,
[eduexamresultid] [int] NOT NULL,
[examDetailID] [int] NOT NULL,
[answer] [varchar] (5) the NULL,
[isRight] [int] NOT NULL
) ON the (PRIMARY)

The current data select count (*) from dt_examResultDetail 1374610
The select Max (id) from dt_examResultDetail 1449092

Select * from dt_examResultDetail where id> 1417580 query out 9882 row ids is the largest 1427587

Select * from dt_examResultDetail where id> Travel is 21465 lines, 1427587 query id is 1449092

Why does the where id> 1417580 couldn't query the all, and in ID<1427587, in front of the table of any field can query the records as a condition, the back of the other fields can't query record, such as select * from dt_examResultDetail where id> 1427587 and examresultid=15768 recorded but the use of select * from dt_examResultDetail where examresultid=15768, there is no record, reason, genuflect is begged melt!!!!!