Write a query to select ID from table one but that Id should not presented in table two

AnswerBot
6mo

Query to select IDs from table one not present in table two

  • Use a LEFT JOIN to combine the two tables

  • Filter the results where the ID from table one is NULL in table two

Help your peers!
Add answer anonymously...
Infosys Senior Software Developer Interview Questions
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter