CREATE TABLE scroe (
no_read nvarchar(40) NULL ,
subject nvarchar(40) NULL ,
score1 int NULL);

INSERT INTO scroe (no_read,subject,score1)
VALUES 
('1','1',50),
('1','2',60),
('2','1',70),
('2','2',50),
('3','1',40),
('3','2',50),
('4','1',80),
('4','2',60),
('4','3',90),
('5','1',65),
('5','2',75),
('5','3',25);

-- 1.no_read 限定在 ('1','2','3'),subject 限定在 ('1','2')
SELECT *
FROM (
SELECT X.no_read,X.subject,X.score1,
X.score1 -
LEAD(X.score1,1) OVER (PARTITION BY X.no_read ORDER BY X.subject)  AS Result
FROM scroe AS X
WHERE X.no_read IN ('1','2','3') AND X.subject IN ('1','2')
) AS Y
WHERE Y.Result>0
ORDER BY Y.no_read

Demo

SELECT t0.[no_read]
      ,t0.[subject]
      ,t0.[score1]
  FROM [MyLab].[dbo].[scroe] t0
	inner join [MyLab].[dbo].[scroe] t1 on t0.no_read=t1.no_read

	where t0.subject<t1.subject and t0.score1>t1.score1

SELECT S1.no_read, S1.SS1
	, S2.SS2
FROM
(
	--取科目1的
	SELECT no_read, score1 SS1
	FROM [dbo].[scroe] (NOLOCK)
	WHERE [subject]='1'
) S1
INNER JOIN --將兩者關聯
(
	--取科目2的
	SELECT no_read, score1 SS2
	FROM [dbo].[scroe] (NOLOCK)
	WHERE [subject]='2'
) S2
	ON S1.no_read = S2.no_read
--這定條件SS2>SS1者
WHERE SS2>SS1

https://stackoverflow.com/questions/24470/sql-server-examples-of-pivoting-string-data