Database and Warehouse Concepts

A highly motivated and ambitious individual able to give timely and accurate advice, guidance, support and training to team members and individuals. Having the ability to work with the minimum of supervision whilst leading a team. Having a proven ability to lead by example, consistently hit targets, improves best practices and organizes time efficiently.

Pages

  • SQL SCENARIOS
  • Snowflake
  • Python
  • PLSQL
  • DWH Concepts
  • Informatica
  • UNIX
  • Teradata
  • Data Modeling
  • Performance Tuning
  • SQL VIDEOS

Wednesday, 10 December 2014

NOT IN vs NOT EXISTS with NULL values


NOT IN and NOT EXISTS are not same

Posted by KVB at 11:30 pm
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL SCENARIOS

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

KVB
View my complete profile

Blog Archive

  • ►  2025 (1)
    • ►  January (1)
  • ►  2022 (3)
    • ►  October (3)
  • ►  2017 (5)
    • ►  November (1)
    • ►  July (2)
    • ►  January (2)
  • ►  2016 (4)
    • ►  February (4)
  • ►  2015 (109)
    • ►  December (1)
    • ►  September (4)
    • ►  August (30)
    • ►  July (42)
    • ►  June (31)
    • ►  May (1)
  • ▼  2014 (31)
    • ▼  December (6)
      • COALESCE operator
      • LIKE operator
      • NOT IN vs NOT EXISTS with NULL values
      • EXISTS vs IN operator
      • Delete based on DATE conditions
      • Eliminating Duplicates from the table
    • ►  September (1)
    • ►  August (4)
    • ►  July (20)

Labels

  • Data Modeling (10)
  • DWH Concepts (23)
  • Informatica (18)
  • Performance Tuning (1)
  • PLSQL (3)
  • Python (3)
  • Snowflake (1)
  • SQL SCENARIOS (58)
  • SQL VIDEOS (1)
  • Teradata (25)
  • UNIX (13)

Total Pageviews

Simple theme. Theme images by luoman. Powered by Blogger.