How do I control only several SELECTs?

xiaoxiao2021-03-06  97

Create Table TBL (ID Int Not Null, Name Char (6)) GoInsert Into TBL VALUES (1, 'A')

INSERT INTO TBL VALUES (2, 'B')

INSERT INTO TBL VALUES (3, 'C')

SELECT TOP 2 * from TBL Where ID Not in (SELECT TOP 5 ID from TBL) Understanding: The first 2 records of the query are not in the top 5

转载请注明原文地址:https://www.9cbs.com/read-96499.html

New Post(0)