Learning from a classic SQL query using a specified number of rows

Today, I am talking with my colleagues about an SQL command to take the specified line.

For example, if a table has 6 data records, the table now has 3 or 4 records.

Code
Declare @ table
(
Id int identity (1, 1 ),
Name varchar (10)
)

Insert into @ table
Select 'songjiang'
Union all
Select 'lin chong'
Union all
Select 'huarong'
Union all
Select 'Li yun'
Union all
Select 'lu zhishen'
Union all
Select 'wusong'

Select * from @ table

Where id in (select top 4 id from @ table) and id not in
(
Select top 2 id from @ table
)

Select top 2 * from
(
Select top 4 * from @ table order by id asc
)
Order by id desc

After performance analysis, the execution efficiency of the first method is much better than that of the second method !!!

Check the SQL analysis results.

First, the query overhead is 21%

Second, the query overhead is 57%