| Author | Message | ||
     Saughmraat Junior Artist Username: Saughmraat Post Number: 438 Registered: 09-2008 Posted From: 202.164.25.5 Rating: |
WARNING: 18+ my daily set of unix commands http://vaderpi.com/blog/?p=33 | ||
| Simba Comedian Username: Simba Post Number: 1619 Registered: 02-2008 Posted From: 122.175.83.231 Rating: |
I saw a girl in NY wearing this shirt: http://www.dylanscandybar.com/resources/dylans/images/produc ts/processed/624-youth-novelty-tee.a.detail.jpg From far, it reads "I CANDY" (EYE CANDY) at the right location  | ||
| Stig Side Hero Username: Stig Post Number: 6297 Registered: 01-2010 Posted From: 117.195.238.104 Rating: N/A |
First post single esaru ..... ardham kaaledu anukunta papam !!  -------- Only seven people have looked The Stig straight in the eyes. They are all dead now !! | ||
| Guttonkay Side Hero Username: Guttonkay Post Number: 6368 Registered: 05-2008 Posted From: 148.87.67.141 Rating: N/A |
enkamma. yedo le mana bachigadu/garu ani vadileste ee reverse ragging enti. I have to ask Stig BGC ekkadaka vachindi ani. My imaginary friend went away for an year in search of his brain! | ||
| Pomegranate_life Junior Artist Username: Pomegranate_life Post Number: 491 Registered: 07-2010 Posted From: 32.97.110.60 Rating: N/A |
Clueless ani advertise chesukunara?  | ||
| Guttonkay Side Hero Username: Guttonkay Post Number: 6367 Registered: 05-2008 Posted From: 148.87.67.141 Rating: N/A |
good ones. I have a t-shirt that says this SELECT * FROM users WHERE clue > 0; 0 rows returned My imaginary friend went away for an year in search of his brain! | ||
| Pomegranate_life Junior Artist Username: Pomegranate_life Post Number: 483 Registered: 07-2010 Posted From: 32.97.110.60 Rating: N/A |
I guess I got it wrong. My interpretation of the Joke was about JOINS and I expanded it "Inner? Outer? , Left Outer? or Right Outer?" as they are also part of the types of joins. But your post seem to imply that you NEED/mandatory to have a "WHERE" clause for JOIN operation and a having clause for "Group by" . AFAIK You don't need a WHERE clause to have a JOIN. You don't need a Having clause on Group By. You ONLY need them when you want to filter out results. | ||
| Abhysg Side Hero Username: Abhysg Post Number: 3507 Registered: 08-2008 Posted From: 71.127.239.157 Rating: N/A |
SELECT department, COUNT(*) as "Number of employees" FROM employees WHERE salary > 25000 GROUP BY department HAVING COUNT(*) > 10;} | ||
| Abhysg Side Hero Username: Abhysg Post Number: 3506 Registered: 08-2008 Posted From: 71.127.239.157 Rating: N/A |
thats 2 apply condition "dept='FINANCE'" | ||
| Pomegranate_life Junior Artist Username: Pomegranate_life Post Number: 479 Registered: 07-2010 Posted From: 32.97.110.60 Rating: N/A |
SELECT DEPT ,MAX(SALARY) ,MIN(SALARY) FROM EMP GROUP BY DEPT
You can have a JOIN without a WHERE clause | ||
| Abhysg Side Hero Username: Abhysg Post Number: 3504 Registered: 08-2008 Posted From: 71.127.239.157 Rating: N/A |
ON used for relation between tables.. where used for condition. group by column need 2 "having" | ||
| Pomegranate_life Junior Artist Username: Pomegranate_life Post Number: 478 Registered: 07-2010 Posted From: 32.97.110.60 Rating: N/A |
Aren't Joins ALWAYS ON? If "where" sneaks into the group, then "Order by" , "Group by" will throw a tantrum. | ||
| Anand_n Side Hero Username: Anand_n Post Number: 7795 Registered: 02-2008 Posted From: 173.174.176.93 Rating: N/A |
SELECT * FROM Orders LEFT JOIN OrderLines ON OrderLines.OrderID=Orders.ID WHERE Orders.ID = 12345 aa chal ke tujhe main leke chalu ik aise gagan ke tale jahan gam bhi na ho, aansoo bhi na ho,bas pyaar hi pyaar pale | ||
| Pomegranate_life Junior Artist Username: Pomegranate_life Post Number: 477 Registered: 07-2010 Posted From: 32.97.110.60 Rating: N/A |
Naaku mee joke ardam kaledu  | ||
| Abhysg Side Hero Username: Abhysg Post Number: 3503 Registered: 08-2008 Posted From: 71.127.239.157 Rating: N/A |
where? | ||
| Mental_sachinodu Side Hero Username: Mental_sachinodu Post Number: 4330 Registered: 10-2008 Posted From: 63.161.147.10 Rating: N/A |
 the world of appearances may or may not be real, or both may and may not be real - or may be indescribable; or may be real and indescribable, or unreal and indescribable; or in the end may be read and unreal and indescribable - its all Syadvada | ||
| Anand_n Side Hero Username: Anand_n Post Number: 7788 Registered: 02-2008 Posted From: 167.24.104.150 Rating: N/A |
Self-referential humor ardham avvali aa chal ke tujhe main leke chalu ik aise gagan ke tale jahan gam bhi na ho, aansoo bhi na ho,bas pyaar hi pyaar pale | ||
| Pomegranate_life Junior Artist Username: Pomegranate_life Post Number: 452 Registered: 07-2010 Posted From: 32.97.110.60 Rating: N/A |
Other SQL responds "Inner? Outer? , Left Outer? or Right Outer?" | ||
| Stig Side Hero Username: Stig Post Number: 6292 Registered: 01-2010 Posted From: 117.195.238.104 Rating: N/A |
A SQL statement walks into a bar and spots a couple of tables. It walks over to them and asks "Can I join you?"
Bavundi !!-------- Only seven people have looked The Stig straight in the eyes. They are all dead now !! | ||
| Anand_n Side Hero Username: Anand_n Post Number: 7787 Registered: 02-2008 Posted From: 167.24.104.150 Rating: N/A |
A T-shirt I bought for my son : "those who think they know everything annoy us who do' aa chal ke tujhe main leke chalu ik aise gagan ke tale jahan gam bhi na ho, aansoo bhi na ho,bas pyaar hi pyaar pale | ||
| Anand_n Side Hero Username: Anand_n Post Number: 7786 Registered: 02-2008 Posted From: 167.24.104.150 Rating: N/A |
 Have to pass this one on to my sonaa chal ke tujhe main leke chalu ik aise gagan ke tale jahan gam bhi na ho, aansoo bhi na ho,bas pyaar hi pyaar pale | ||
| Stig Side Hero Username: Stig Post Number: 6290 Registered: 01-2010 Posted From: 117.195.238.104 Rating: N/A |
When a third grader was asked to cite Newton's first law, she said, "Bodies in motion remain in motion, and bodies at rest stay in bed unless their mothers call them to get up." !! ---- Heisenberg went for a drive and got stopped by a traffic cop. The cop asked, "Do you know how fast you were going?" Heisenberg replied, "No, but I know where I am." -------- Only seven people have looked The Stig straight in the eyes. They are all dead now !! | ||
| Stig Side Hero Username: Stig Post Number: 6289 Registered: 01-2010 Posted From: 117.195.238.104 Rating: N/A |
 -------- Only seven people have looked The Stig straight in the eyes. They are all dead now !! | ||
| Stig Side Hero Username: Stig Post Number: 6288 Registered: 01-2010 Posted From: 117.195.238.104 Rating: N/A |
oops! mee post cholledu !! -------- Only seven people have looked The Stig straight in the eyes. They are all dead now !! | ||
| Anand_n Side Hero Username: Anand_n Post Number: 7785 Registered: 02-2008 Posted From: 167.24.104.150 Rating: N/A |
Beat you to it i and pi are having a heated argument... i : for god's sake why can't you be rational ? aa chal ke tujhe main leke chalu ik aise gagan ke tale jahan gam bhi na ho, aansoo bhi na ho,bas pyaar hi pyaar pale | ||
| Stig Side Hero Username: Stig Post Number: 6287 Registered: 01-2010 Posted From: 117.195.238.104 Rating: N/A |
An atom walks into a bar and says to the bartender: "I think I left a electron here last night." The bartender says: "Are you positive?" -------- Only seven people have looked The Stig straight in the eyes. They are all dead now !! | ||
| Anand_n Side Hero Username: Anand_n Post Number: 7784 Registered: 02-2008 Posted From: 167.24.104.150 Rating: N/A |
Hydrogen atom: Shucks, I just lost an electron Bartender : Are you sure? Hydrogen Atom : I am positive. aa chal ke tujhe main leke chalu ik aise gagan ke tale jahan gam bhi na ho, aansoo bhi na ho,bas pyaar hi pyaar pale | ||
| Stig Side Hero Username: Stig Post Number: 6286 Registered: 01-2010 Posted From: 117.195.238.104 Rating: N/A |
Q: How many programmers does it take to change a light bulb? A: None. It's a hardware problem. -------- Only seven people have looked The Stig straight in the eyes. They are all dead now !! | ||
| Stig Side Hero Username: Stig Post Number: 6285 Registered: 01-2010 Posted From: 117.195.238.104 Rating: N/A |
A neutron walks into a bar; he asks the bartender, 'How much for a beer?' The bartender looks at him, and says 'For you, no charge.' -------- Only seven people have looked The Stig straight in the eyes. They are all dead now !! | ||
| Ishan Side Hero Username: Ishan Post Number: 5138 Registered: 01-2009 Posted From: 128.249.106.234 Rating: N/A |
he he baagunnayi | ||
| Stig Side Hero Username: Stig Post Number: 6284 Registered: 01-2010 Posted From: 117.195.238.104 Rating: |
So, Helium walks into a bar and orders a beer .... The bartender says, "Sorry, we don't serve noble gases here." Helium doesn't react. --- A superconductor walks into a bar. The bartender says "we don't serve superconductors here." The superconductor leaves without putting up any resistance. --- A higgs-boson walks into a church. The priest says "higgs-bosons aren't allowed in here." The higgs-boson says "but without me, how can you have mass?" --- To get to the other side. Why did the tachyon cross the road? --- Schrodinger's cat walks into a bar and doesn't. --- A parasite walks into a bar. The bartender says "we don't serve your kind in here." The parasite says "well you're not a very good host." --- A neutrino walks into a bar. The bartender says "we don't serve neutrinos in here." The neutrino says "I was just passing through." -------- Only seven people have looked The Stig straight in the eyes. They are all dead now !! |
