₦airaland Forum

Try 'distinct'' keyword and specify the columns to be selected

select distinct acc_no, depositor, depositAmt from.....

Better still restructure the SQL using subquery, you can use row_number. If you explain exactly what you want to achieve and the structure of your tables, then it will be easier to decipher a solution.

If you are an intermediate or advanced enthusiastic beginner Enterprise Java Programmer with knowledge of the the following technologies who wants to learn how to hack and build systems single-handedly with knowledge of front-end, middleware and back-end/database development.

1) Java Enterprise Edition (JSP, JSF, Servlets)
2) OOP, MVC
3) HTML5, Bootstrap, JavaScript
4) SQL and MySQL
5)Tomcat and/or Glassfish Server
6) Netbeans or Eclipse

You don't basically need all these, once you are comfortable coding in Java with sound OOP understanding, if you are a fast learner, you will learn on the job. You can get up to N50,000 stipend per month on completion of task (definitely, I believe you can). Retention after three months possible.

You will work remotely, Lagos or Abuja preferred.

Call send mail to info@topazictsolutions.com for short term engagement, work and learn on live projects.

You can call or text 08178638013

what else do they expect from a president whose brain is damaged.The guy is not thinking well.

Ohakim is one of those educated fools who have found their way into the corridors of power by accident and he is as confused as Obama.

We only hear news when it stale and decide to escalate it when it becomes inconsequential.Late Gani(may his soul rest in peace) said this a long time ago before he died and Nigerians didn't care.Now the Margret Thatcher of Nigeria has her iron grip on us assisted by a deadly cabal who are profiteering from the siege.

Turai for president 2011

thunder fire Ogbulafor

asha 80:
I thought we are the giant of africa

The giant of Africa is taking a long nap!

I think its time to visit Saudi Arabia

Any action they intend to take to forestall any terrorist attack on planes,is good step in the right direction.If only you have been on a plane that wanted to crash and later God intervened and saved you people.You will realize how helpless and mind boggling it can be.Even atheists,native doctors and the rest unbelievers realize how close everyone is close to death and then they start beckoning on Jesus to save them.

Our constitution stipulates thus

144. (1) The President or Vice-President shall cease to hold office, if -

           (a) by a resolution passed by two-thirds majority of all the members of the executive council of the Federation it is declared that the President or Vice-President is incapable of discharging the functions of his office; and

           (b) the declaration is verified, after such medical examination as may be necessary, by a medical panel established under subsection (4) of this section in its report to the President of the Senate and the Speaker of the House of Representatives.

   (2) Where the medical panel certifies in the report that in its opinion the President or Vice-President is suffering from such infirmity of body or mind as renders him permanently incapable of discharging the functions of his office, a notice thereof signed by the President of the Senate and the Speaker of the House of Representatives shall be published in the Official Gazette of the Government of the Federation.

   (3) The President or Vice-President shall cease to hold office as from the date of publication of the notice of the medical report pursuant to subsection (2) of this section.

   (4) the medical panel to which this section relates shall be appointed by the President of the Senate, and shall comprise five medical practitioners in Nigeria:-

           (a) one of whom shall be the personal physician of the holder of the office concerned; and

           (b) four other medical practitioners who have, in the opinion of the President of the Senate, attained a high degree of eminence in the field of medicine relative to the nature of the examination to be conducted in accordance with the foregoing provisions.

   (5) In this section, the reference to "executive council of the Federation" is a reference to the body of Ministers of the Government of the Federation, howsoever called, established by the President and charged with such responsibilities for the functions of government as the President may direct.

Nigerian madness-A president who is sick for close to 60days has not deemed it fit to hand over to VP to prevent his nation from sliding into chaos and further downward on its inglorious development level, pending his death or recovery.We are now buoying our courts with the onerous decision of usurping a man who has not been able to address or discharge his duties for so long,something that the executive council of Nigeria are meant to orchestrate if they are genuine people and are really in Abuja to serve the people of this nation.

If a president cannot appear on camera and is not able to address his nation for close to sixty days,Is he okay? Even at a time that Obama spoke from his Hawaii holidays because of the bomber incident Yar'Adua kept mute and deemed the incident inconsequential.No Sallah,Christmas and new year massages.He has not spoken to his ministers all this while.How else should it be proven that he is incapable of holding that office.I even expected the Hospital to become a microcosm of Aso Rock but nobody except Turai is allowed to see him.It was our dead man president who was giving ultimatum to Camara and Niger,now look at us!Even Camara of Guninea who was shot in the head is better than Yar'Adua because he took a great decision from his hospital bed, by including the opposition in the government.I wonder if Nigeria can stand without shame and have the impetus to speak to any African country on issues of its leadership in the nearest future.

Is raising money for campaign bad?

tpia.:
freedom of expression does not include irritating others with your unnecessary gifs. People have been banned for using too many gifs before on this forum and I dont see any reason why beaf should be an exception.

There are emoticons he can use to show whatever it is he thinks he's feeling. He's gone overboard with his frivolence. Others can also reply him using the same, and its not a weakness that people are too civil to do so.

I have my own freedom of expression to request he be banned for being a nuisance with his gifs.

If you're enlisted as a soldier in his guerilla army, then bring out your other arguments in his favour.

Don't wanna argue with ya.There's a guy called chapelle.s whose posting privileges were denied yesterday.He reappeared as igweojoto and met the fate.Find out what he did to kosovo and debosky,then you now tell me if you want to argue with me.

Freedom of speech should not be censored.What you say can irritate other people because everyone does not have the same level of tolerance.However only when you become negative or provocative that some censorship should be applied.The gifs posts are rather funny than provocative.

Nigeria is not a country where citizens opinions changes anything.I am waiting on fate,change and the Invisible hand to intervene as usual.Who killed Abacha?

tpia.:
Beaf's gifs should be enough to get him banned, imo.

He's overdoing it.

If he cant use the forum emoticons like everybody else then he shouldnt use any at all.

I can see that certain folks are on Nairaland basically to get people banned and limit their freedom of expression.If they are given Nigeria to rule,I bet all of you, we will have worst Gitmos in large numbers.

@poster

Incredulous! Can you explain what you mean by online protest?

Is it not Nolly wood and Hollywood.The musicians want to be like their US folks too.They will also take their portion of the barrage of unsuccessful marriages that rocks that industry.

none of them!

They reported Abacha's death,they think that they still got potency or credibility about Nigerian issues.They think that Nigeria is still the same colony they use to know before.

PapaBrowne:
If at all that was Yar Adua, then one thing is obvious- He wasn't told about the Nigerian terrorist!
How could he be talking about Super Eagles when Nigeria is almost on fire?

I sympathise with the guy sha, he is also a victim of the cabal! I hope he resigns then recovers.

They told us that his brain is damaged and you folks think that it is a lie.That is how a damaged brain works.He was thinking that football is the anesthesia to all of our woes including the botched terror attack.If a president could not deliver simple Sallah,Christmas and new year massages,what has become of him.Last year,the Thai King had to be wheeled from hospital to talk to his people.He is a ceremonial head.In our case,no word from an executive head of state for 50days.This is made in Africa.Its only in our continent that such things happen.Most times I don't blame the white folks when they treat Africa as second class humans.

Allta:
Believe it or not, Yaradua is on life support and that BBC interview wasn't him , but whatever the case is, the country has to move forward, the country is not any body's father's or grandfather's or great grandfather's property!!!! What's the point of having a democracy without a President? Yah All think this could happen if it were a military government we're under?

I will advice Thuraya to learn from Ariel Sharon's case of Isreali who suffered from stroke and up till now is currently in a persistent vegetative state after suffering a stroke on 4 January 2006.

A word is enough for the wise , let's not give the military a chance to get close to the Aso rock again, I mean, what will the Yaradua family benefit if the military assume operations for Aso Rock now? Bunch of selfish self-glory ba5tard5!!!!!!!!!!!!

I heard the purported interview on Al-jazeera.That's not Yar'adua.Its a stimulation.Don't mind the animals who are playing chess and poker with Nigeria.We cannot continue like this for a long time to come.Believe me.Its either Yar'Adua can board a plane and come back or not.Even if he spends six months in Jeddah.We can only wish for the best but the unexpected may befall us soon-chaos and anarchy.

Kudos to the men and women who came out with genuine concerns for the liberation of Nigeria.

I will continue to ask,what do Nigerians want? Is it a president who grants interview from Jeddah or one who will report to Aso Rock and manage the country that he eloped from over 50 days ago? What the Abuja henchmen are looking for will soon betide them.That chaos and anarchy will soon be let loose among men in Nigeria and bodies will litter the streets before change is come.

Why player hating? I think Nigeria needs to sort their own mess out, not blame Ghana Its a competitive arena, everybody fighting for development, if the Ghanaian environment is more favourable for an HQ why not go for it. Remember they are not running a charity, this is a business, if Nigerians are able to get one voice I am sure you can can boycott MTN - but this seems 100%unlikely - based on your track record. Nigeria cant even agree on distributing its oil resources properly, a failed state now the only country in Africa involved in terrorism

I am a christian and I am vehemently against terrorism of any kind.I guess you are not from Africa or you are not informed.Have you ever heard of Somalia,Sudan,Libya,the Congo brothers and Eritrea.They are all African countries Google them or check their history and also get info from US.gov on them.

When a set of people prefer a 'dead' president to over 150million able bodied citizens,what are we going to call that?

pls i need the latest oracle dumps.I was informed that the current exam is in three modules. plz contact me @ frankgod02@gmail.com.I will pay for it.I want to write the exam in two weeks

Threat or no threat,the oil must be sold.China has overtaken the US in annual car sales totaling about 13million last year according to recent reports.Those cars must be fueled.

'price' LMAO catch me if you can!

Make money through this site wwwagloco.com/r/BBHS3263

With our country on the blacklist and low internet penetration as judged by some international agencies.I have always tried as a jobless gradute, to look for a means of catching on the internet work at home to get something for a living.Until recently I was invited to join a new project which I will describe below.I made some inquiries as to whether Nigerians could join and I was told yes,so fellow Nigerians check this out.Heres is the summary.This one they are giving us a chance trust Niger Ninjas.

I recently joined AGLOCO because of a friend recommended it to me. I am now promoting it to you because I like the idea and I want you to share in what I think will be an exciting new Internet concept.


AGLOCO’s story is simple:


Do you realize how valuable you are? Advertisers, search providers and online retailers are paying billions to reach you while you surf.  How much of that money are you making? NONE!


AGLOCO thinks you deserve a piece of the action.


AGLOCO collects money from those companies on behalf of its members. (For example, Google currently pays AOL 10 cents for every Google search by an AOL user. And Google still has enough profit to pay $1.6 billion dollars for YouTube, an 18-month old site full of content that YouTube’s users did not get paid for!


AGLOCO will work to get its Members their share of this and more.


AGLOCO is building a new form of online community that they call an Economic Network. They are not only paying Members their fair share, but they’re building a community that will generate the kind of fortune that YouTube made. But instead of that wealth making only a few people rich, the entire community will get its share.


What's the catch? No catch - no spyware, no pop-ups and no spam - membership and software are free and AGLOCO is 100% member owned. Privacy is a core value and AGLOCO never sells or rents member information.


So do both of us a favor: Sign up for AGLOCO right now! If you use this link to sign up, I automatically get credit for referring you and helping to build AGLOCO. http://www.agloco.com/r/BBHS3263

Thanks