How do I control only several SELECTs?

xiaoxiao2021-03-06  107

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)