Monday, July 8, 2019

Sql Server | EXISTS | ANY USING SQLSERVER


//WILL SHOW WITHOUT DUPLICATE DATA

select  *
FROM  tbl_test1
WHERE 
EXISTS (SELECT 1 FROM  tbl_test2 c WHERE id= l.ID)
AND NOT EXISTS (SELECT 1 FROM  tbl_test3 c WHERE c.D = l.ID)
AND NOT EXISTS (SELECT 1 FROM  tbl_test4 c WHERE c.ID = l.ID)
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

javascript Filter/index off

 var family = [{"name":"Jack",  "age": 26},               {"name":"Jill",  "age"...

  • VLOOKUP FOR Display product with respective quantity
    A3+C3 VLOOKUP(G3,$A$3:$B$10,2) sum Product Quantity Count Result 1 Mobile 2 1 Mobile 3 Keyboard 3 2 Mobile 6 TV 1 3 ...
  • EF Core
    EF CORE CLI > dotnet ef database update MyFirstMigration. Scaffold-DbContext Command Use Scaffold-DbContext to create a model based ...