Day 2 Day Learning

Thursday, January 31, 2013

Sum of two or more independent count querries

I got a situation where I needed sum of two independent table counts, had too search and got a querry as below.


Select count1 + count2 as total from
(Select count(*) as count1 from TABLE1 an where ....),
(Select count(*) as count2 from TABLE2 atf where ....)
Posted by Mahesh Pujari at 7:09 AM

No comments:

Post a Comment

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

My Blog List

  • @Blog("Baptiste Wicht")
    Trying out Rust and C++26
    1 month ago
  • Alexey Ragozin
    SJK is learning new tricks
    7 years ago
  • David Dice's Weblog
    Reflecting Changes in Business Objects in UI Tables with Visual Builder
    7 years ago
  • The Art and Craft of Great Software Development
    KMSPico 10.0.9 Windows 10 Terbaru 2016 Free Download
    9 years ago
  • Gustavo Duarte
    Added Best Of Page, Back to Writing
    14 years ago

About Me

My photo
Mahesh Pujari
View my complete profile

Blog Archive

  • ►  2017 (1)
    • ►  January (1)
  • ▼  2013 (6)
    • ►  May (1)
    • ►  March (1)
    • ►  February (2)
    • ▼  January (2)
      • Daily activities Day 1 ;)
      • Sum of two or more independent count querries
  • ►  2012 (3)
    • ►  June (1)
    • ►  April (1)
    • ►  January (1)
  • ►  2011 (9)
    • ►  December (2)
    • ►  September (2)
    • ►  July (3)
    • ►  March (1)
    • ►  February (1)
  • ►  2010 (3)
    • ►  November (2)
    • ►  July (1)
Awesome Inc. theme. Powered by Blogger.