Hi Team I have this query, how do you explain this result and ways to avoid that it does not happen in sql server.? SELECT * FROM runners WHERE id NOT IN ( SELECT winner_id FROM races) // output Id column empty name column empty

Select all runners detail (from runners table) who are not winner in race (as per races table record). You can say it as, runner details who never won any race till date.

Hello, Your query will select only those record which are not in races table but in runners table.Can please explain your question in brief?

Sachin i know that mate, but the issue here i am using sql server 14, how will this prevent from exposing the values?

Those who are not winners are runners, what do you want to ask?

Answers

How to explain this logic and ways to avoid?

Guest User

695

Hi Team

I have this query, how do you explain this result and ways to avoid that it does not happen in sql server.?

SELECT * FROM runners WHERE id NOT IN (SELECT winner_id FROM races)
// output
Id column empty
name column empty

Answers (4)

Next Recommended Forum

When I run my mvc solution from another user it doesn’t connect to sql

Query to return all lists of invoices ordered by billing date?

Leaderboard

View all

Rodrigo Diaz

-1

Dr Naveen Sharma

+11

Mahesh Chand

View all

Yesterday's leader

Rodrigo Diaz

Software Architecture, Cloud computing, Cloud-native apps, AI, .NET, C#

Mexico

173

13.2k

11k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

186

290.9k

10.5k

500

Upcoming events

View all

Suggested for you

View all

Rupenkumar Anjaria

Shanuka Maheshwaran

Rohanathan Suresh

Yuvapriya P

Atharva Urade

Forum Statistics

Please welcome our newest member Chester Hunt.
3,077,943 users have contributed to 147,418 threads and 483,397
In the past 24 hours, we have 8 new threads, 32 new posts, and 67 new users.
In last week, the most popular thread is 'ItemId is not able to save into the tblQuantities'.