Loading

sqlserver

14y1.4k

i have following fields such as

Sno Location Owned Leased

1 chennai ltd          gro

2 delhi          Lcc          nestle

3 coimbatore Lco          musicword

4 Mumbai          Aircell          Vacant

in that i want the output Sno 3 and 4 datas only.

for that in sql through query how to use not in.

i remember we use not in query through sql how to do for my above question please send the query.

Rgds,
Narasiman P

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
hi,

Agree with Muralidharan Dheenadhayalan for "not in" SQL server,

However "Not IN" Decrease Performance of Query
suggest to use "NOT EXISTS".

hope this will help.
0
Satyapriya Nayak14y ago
Hi Narasiman,

You can do it in another way also

SELECT * FROM test WHERE (sno = 3) OR (sno = 4)

Thanks
0
Kunal Vaishya14y ago
Dear ,
tell us in details so we can help you
0
14y ago
On what basis, you want to filter 3 & 4 records.

select * from table1 where sno not in (1,2).
0