₦airaland Forum

Welcome, Guest: RegisterLoginWith GoogleTrendingRecentNew

Stats: 3,326,111 members, 8,425,022 topics. Date: Friday, 12 June 2026 at 12:43 AM

Toggle theme

Noblecx's Posts

Nairaland ForumNoblecx's ProfileNoblecx's Posts

1 2 3 4 5 6 7 8 9 10 (of 12 pages)

ProgrammingRe: Select All Rows Where The Sum Of Column Equals A Value by Noblecx: 10:37pm On Dec 25, 2016
BobAxelrod:
which database is this, not working for me
MSSQL
ProgrammingRe: Select All Rows Where The Sum Of Column Equals A Value by Noblecx: 2:26pm On Dec 25, 2016
BobAxelrod:
No, it shouldn't be greater than, if 5 is not available then the database shouldn't return any result
This is what I was able to come up with.


Select col1, col2
From yourTable
Where sum = 5
IN
(Select col1, col2, (col1 + col2) as sum
From YourTable)

ProgrammingRe: Select All Rows Where The Sum Of Column Equals A Value by Noblecx: 1:38pm On Dec 25, 2016
BobAxelrod:
No, it shouldn't be greater than, if 5 is not available then the database shouldn't return any result
OK, Got that, You gonna need a sub query, I will get back to you
PoliticsRe: Emeka Offor's Christmas Gifts To 2000 Widows As She Invites Mrs Okorocha (Pics) by Noblecx: 7:34am On Dec 25, 2016
Igbo amaka...

At least no how no how, Christmas Don sure for them
PoliticsRe: Facebook Man Gives Solution To Pres. Buhari On Economics by Noblecx:
So the governor of Central bank is buhari minister?
What kind of jackasses that are induced with hunger and starvation are we getting introduced to each day.

Is either the op that post this rubbish needs a brain surgery or the original writer needs one... Or even both of them.
ProgrammingRe: Select All Rows Where The Sum Of Column Equals A Value by Noblecx: 10:11pm On Dec 24, 2016
BobAxelrod:
The table has just two columns col 1 and col 2

Col 1 is the ID, and col 2 is the amount

Let's say I need to select all rows where the sum equals 5 .
It should return row 1 and 2 coz the values there are 2 and 3 i.e 2+3 =5

How do I go about it
OK, if I should get you clearly, you need to get all rows whereby the sum of col1 and col2 = 5?
Even can the sum be greater than 5?
ProgrammingRe: Select All Rows Where The Sum Of Column Equals A Value by Noblecx: 5:52pm On Dec 24, 2016
Explain better, maybe with another illustration
PoliticsRe: Igbo, Biafra, Christmas And Security Checkpoints by Noblecx: 5:22pm On Dec 24, 2016
[s]
HungerBAD:
This writer and write up is very biased.

This does not require a lot of write up. What exactly do the Easterners want?how did this guy even come up with the N250 Million figure?

I mean,why do the Easterners have to always view anything done by anybody not an Easterner suspicious?like sending of security Agents to the East this EMBER month?and even if an Easterner is sent out to offer help,they still view them with distrust.

Same Igbo people that call Okorocha an Hausa man,and have labelled Ekwueme a sellout to the North.

To the Writer. For many years now,the East has gotten a reputation as a place where nobody goes near in the festive period.

This Government saw this as a problem,and deployed security apparatus to help the Eastern Citizenry,from Kidnaps and Robbery,and this writer is comparing it to an occupation of the East by the Federal Government.

If this same Government don't help to protect the East,same writer will say the APC Govt hates the East.

When was the last time anybody heard of kidnappings or Robberies in the East again?

This is a mischievous write up,and this victim playing card bandied around by the Easterners should stop.

You guys should tell Buhari THANK YOU.

You are welcome.
[/s]
You really are not okay...
SE HAS been welcoming influx of Igbos coming back for reunion during Christmas.

Now every fg agencies are now taking advantage of it and this is the robbery, property kidnapping that we are seeing not anything else.
Their presence is now a menace to us.

And Please can you tell them to come over to your own region now? Thank you.

PoliticsRe: President Buhari's Christmas Message To Nigerians by Noblecx: 2:58pm On Dec 24, 2016
Buhari I been think say you stubborn...

Still a great message with a bad messenger.
PoliticsRe: Police Shoots IPOB Man Who Just Came Back 4rm Indonesia 4 His Wedding Dead(pics) by Noblecx: 12:34pm On Dec 24, 2016
Nigeria is never a country one should be proud of.
Rip dear
CelebritiesRe: Tekno Shades Headies Organisers At Rhythm Unplugged' by Noblecx: 11:38am On Dec 24, 2016
Nice one tekno
PoliticsRe: Christmas: Umahi Despatches Buses To Transport Ebonyians In Diaspora by Noblecx: 11:18am On Dec 24, 2016
Afam4eva:
How will they know people who are from Ebonyi? Anybdy can enter the bus and claim to be from Ebonyi.
That one is not a problem. Believe me Bro.
PoliticsRe: Pics News:aregbesola Commissioning Omoluabi Mortgage Bank by Noblecx: 6:11pm On Dec 23, 2016
non-governmental Commercial banks are now project a state govt is banking on as achievement... Better smh undecided
PoliticsRe: Trending Now( #notoroadblocksinsoutheast by Noblecx: 4:49pm On Dec 23, 2016
The roadblocks are just too much to bear.
These people are just violent tout beggars
PoliticsRe: Budget: Gov. Okorocha Presents 2017 Budget To Imo State House Of Assembly (pics) by Noblecx: 4:44pm On Dec 23, 2016
Ahmed0336:
I tire o atleast Rochas is properly dressed unlike fayose
You mean fayose the soldier man dresser abi the spiderman dresser? cheesy

PoliticsRe: Budget: Gov. Okorocha Presents 2017 Budget To Imo State House Of Assembly (pics) by Noblecx: 4:37pm On Dec 23, 2016
EgusiSoup:
Igbo men like to copy what yoruba men used to do because Fayose do then they want to do undecided
No vex, wetyn fayose do?
PoliticsRe: The Only Way To Have Stable Electricity--Fashola by Noblecx: 4:35pm On Dec 23, 2016
grin
Minister of darkness.
PoliticsRe: Nnamdi Kanu's Mother Mobbed By Excited Traders At Ariaria Market In Aba. Photos by Noblecx: 4:27pm On Dec 23, 2016
Bishops10:
I'm presently on one now
Flower in Prison
Tebbie Mama=Queen Dowagar
Interesting I'vnt watch that...
Gonna check that out. wink
EducationRe: Nigerian Lady Is Best Graduating Student Of Project Mgt. At UK University by Noblecx: 1:50pm On Dec 23, 2016
chiefolododo:
Your parents go think say dey born pikin

EducationRe: Nigerian Lady Is Best Graduating Student Of Project Mgt. At UK University by Noblecx: 1:46pm On Dec 23, 2016
Metroescobar:
It is the 7th ranked university in the uk you this hopeless good for nothing tribalist savage! Google is your friend!
LOL... I agree, 7th ranked University can be for anything...

Maybe ranked 7th for being the worst University just like kemi's grin

PoliticsRe: DSS Arrests Ikenga Ugochinyere, Saraki’s Aide Over Plot Against FG by Noblecx: 11:44am On Dec 23, 2016
OZAOEKPE:
Africa is cursed...
You can say that again.
EducationRe: Nigerian Lady Is Best Graduating Student Of Project Mgt. At UK University by Noblecx: 11:36am On Dec 23, 2016
cstr19:
It is a third rate university. They must have pumped her full of backward socialism that adeosun is unleashing on innocent Nigerians.
You wicked. cheesy

EducationRe: Nigerian Lady Is Best Graduating Student Of Project Mgt. At UK University by Noblecx: 11:35am On Dec 23, 2016
Adeevah:
Yoruba again


IPOB...can u see that
Yes we can see one thing which is

Afonja and substandard foreign schools

EducationRe: Nigerian Lady Is Best Graduating Student Of Project Mgt. At UK University by Noblecx: 11:32am On Dec 23, 2016
Hope the University is not like the one that Reno omokiri said that the clueless finance minister went to lipsrsealed

Just saying
PoliticsRe: Nigeria In 2014 And Nigeria In 2016 Compare And Contrast(photo) by Noblecx: 11:28am On Dec 23, 2016
If the president and vice-president of Nigerian APC zombies looks like this...
How will the zombies look like?

PoliticsRe: Nnamdi Kanu's Mother Mobbed By Excited Traders At Ariaria Market In Aba. Photos by Noblecx: 11:23am On Dec 23, 2016
cheruv:
When the time comes,she'd be crowned empress dowager cool
To much of Korean movie Bro...
I love to watch Korean traditional movies.
PoliticsRe: Nnamdi Kanu's Mother Mobbed By Excited Traders At Ariaria Market In Aba. Photos by Noblecx: 10:29am On Dec 23, 2016
kenonze:
Sycophants
You don't have to mess the thread with your disgruntled itch for nuisances
PoliticsRe: Nnamdi Kanu's Mother Mobbed By Excited Traders At Ariaria Market In Aba. Photos by Noblecx: 10:27am On Dec 23, 2016
Great woman of valour who begets a great son

1 2 3 4 5 6 7 8 9 10 (of 12 pages)