Wednesday, March 23, 2011

SQL Scalar functions

Diffending on input value this function will returns the single value.

•UCASE() - Converts a field to upper case
•LCASE() - Converts a field to lower case
•MID() - Extract characters from a text field
•LEN() - Returns the length of a text field
•ROUND() - Rounds a numeric field to the number of decimals specified
•NOW() - Returns the current system date and time
•FORMAT() - Formats how a field is to be displayed

SQL Aggregate Functions

Diffending on value in column this function will return a single value.


•SUM() - Returns the sum
•COUNT() - Returns the number of rows
•FIRST() - Returns the first value
•LAST() - Returns the last value
•MAX() - Returns the largest value
•AVG() - Returns the average value

Wednesday, March 16, 2011

See Before and after disaster pic of Japan

Move the slider to compare satellite images from before and after the disaster.



http://www.nytimes.com/interactive/2011/03/13/world/asia/satellite-photos-japan-before-and-after-tsunami.html?hp

Tuesday, March 15, 2011

Opening for Service Engineer-B​angalore

Department: UPS and Power Products

Position: Service Engineer

Location: Bangalore

Profile:
He is responsible for Resolving customer issues
Installing,repairing ,testing the equipment
Maintaining the performance of the products

CTC:upto-1.2 P.A.
B.E. freshers can also apply

If interested in the opening kindly revert with your updated CV with current CTC and Expected Mentioned.

NOT TRUE: BBC News Flash Report: Japan government confirms radiation leak at Fukushima nuke plants

Since the news spread out about the possible meltdown of Japan's nuclear reactor in Fukushima due to the strong earthquake last Friday, there has been fictitious text/SMS messages circulating around the Philippines. The text message warns that the radiation from the problematic nuclear plant will reach the Philippines and other Asian countries today and everybody is advised to stay indoors for their safety especially when it rains. Here's one variation of that text message:



BBC FLASHNEWS: Japan government confirms radiation leak at Fukushima nuclear plants. Asia countries should take necessary precautions. If rain comes, remain indoors first 24hrs. Close doors & windows. Swab neclskin with betadine where thyroid area is, radiation hits thyroid first. Take extra precautions. Radiation may hit Phil at starting 4pm today. Pls send to your loved ones.


If you received a similar text message: DO NOT BELIEVE IT! DO NOT FORWARD IT! It's a false warning designed to spread unnecessary anxiety and confusion.

Thursday, March 10, 2011

What is your salary per Minute

Shah Rukh Khan

What: Actor
How much: Rs 247 per minute


The King Khan, who started off modestly as a 'Fauji', made about Rs 13
crore last year. This included his endorsement deals for Pepsi, Hyundai
Santro - and of course, wetting himself in a bathtub, surrounded by women
for HLL's Lux. How much per minute?


Brij Mohan Lall Munjal

What: Chief of Hero Group
How much: Rs 255 per minute




The patriarch of the Hero Group received the Life-time achievement award
for 'Excellence in Corporate Governance' by the Institute of Company
Secretary of India this year. Brij Mohan Lall Munjal earned about Rs 13.4
crore last
year. He continues to be the world's largest motorcycle manufacturer and
fuels his bank balance with Rs 255 per minute.


Sachin Tendulkar

What: Cricketer
How much: Rs 1,163 per minute




India's most loved sportsman makes a lot more than most CEOs of Indian
companies; going by his annual remuneration for 2004-2005. Breaking it
down, his three-year contract for endorsements is worth Rs 180 crores. He
is also paid Rs 2,35,000 for a five-day test match and Rs 2,50,000 for one
dayers.

A little bit of elementary math: This highest paid cricketer in the world
makes around Rs 61.15 crore a year, or Rs 1,163 per minute


Dr A P J ABDUL Kalam

What: President of India
How much: Rs 1.14 per minute




Before taking on the reins of this country, Dr A P J Kalam played a leading
role in the development of India's missile and nuclear weapons programmes -
so much so - that he's fondly referred to as the 'Missile Man'. In the
early
1990s, he served as scientific adviser to the government, and his prominent
role in India 's 1998 nuclear weapons tests established Kalam as a national
hero. For all his work in his present capacity as President of the world's
largest de mocracy, Kalam draws an annual remuneration of Rs 6,00,000 or Rs
1.14 per minute.


Mukesh Ambani




What: CMD of Reliance Industries Ltd
How much: Rs 413 per minute

Head honcho of the $16.5 billion Reliance Industries Limited, Mukesh Ambani
was ranked the world's 56th richest man in Forbe's list. But since this is
only about salaries (and the like), we'll completely ignore his other
earnings. Last year, Mr Ambani earned Rs 21.72 crore; a neat growth of 87
per cent over his previous year's earnings. He makes not less than Rs 413
per minute.


Amitabh Bachchan

What: Actor
How much: Rs 361 per minute



Kaun Banega Crorepati? Apparently, Mr Bachchan! With more endorsements and
film releases per year than successful actors half his age, Bachchan's
take-home last year was around Rs 19 crore - that's Rs 361 per minute.


Dr Manmohan Singh

What: Prime Minister of India
How much: Rs 0.57 per m inute



An economist by profession, Dr Singh has formerly served in the
International Monetary Fund. His economics education included an
undergraduate and a master's degree from Punjab University ; an
undergraduate
degree from Cambridge ; and a doctorate from Oxford University . One of the
most educated Indian prime ministers in history, Singh also served as the
finance minister under prime minister Narasimha Rao. In his present
capacity, Singh is paid Rs 3,60,000 annually, i.e. Rs 0.57 per minute.


Indra Nooyi

What: New Pepsi Chief
How much: Rs 2,911 per minute (from October 11)




Chennai-born 50-year-old Indra Nooyi was the Chief Financial Officer (CFO)
of PepsiCo, the US-based soft drink major. In that capacity, her
remuneration stood at $5 million (over Rs 23 crore). With her promotion
this
year, Nooyi becomes one of the highest paid CEOs in the world, with an
announced remuneration of $33 million (approximately Rs 153 crores). This
means Nooyi makes a whopping Rs 2,911 per minute.

*All figures based on media reports

Don’t put your cell number on Facebook

On Tuesday 18 January 2011, 12:01 AM

Sydney, Jan 17 (ANI): A security expert has warned that users should remove their home addresses and phone numbers from their Facebook accounts

Graham Cluley said the website now gives third parties access to that information.

The website said in a blog post at the weekend that it would give developers of applications access to the contact information of users who install their apps.

"These permissions must be explicitly granted to your application by the user via our standard permissions dialogs. Please note that these permissions only provide access to a user's address and mobile phone number, not their friend's addresses or mobile phone numbers," the Sydney Morning Herald quoted Facebook's Jeff Bowen as saying.

However, Sophos security expert Cluley, has raised doubts over the move.

"You have to ask yourself - is Facebook putting the safety of its 500+ million users as a top priority with this move?" he said.

"It won't take long for scammers to take advantage of this new facility, to use for their own criminal ends."

Cluley advised that users should take personal info such as home addresses and mobile numbers off their pages.

"You can imagine, for instance, that bad guys could set up a rogue app that collects mobile phone numbers and then uses that information for the purposes of SMS spamming or sells on the data to cold-calling companies," he said. (ANI)

Tuesday, March 8, 2011

Reserve Bank of India launched 150 Rupee Coin



India celebrating the Rabindranath Tagore's 150th birth anniversary. On this celebration Reserve Bank of India launched the 150 Rupee coin in the memory of Nobel Winner Sir Rabindranath Tagore. Newly launched 150 Rupee coin is about 40 mm in diameter and It's weighs is about 35 grams. The coin of 150 Rupee contain Rabindranath Tagore image on one side and on another side it will contain the image of Ashok Stambha.

Thursday, March 3, 2011

Bangalore univercity made mandatory that a student clears at least 50% of the subjects to become eligible for promotion to the next semester

Currently, Bangalore University students, under the complete carryover system, can get into the next semester without clearing even a single subject in the previous semester.
“Under the existing system a student will be promoted to the next semester even if he doesn’t attend the exam. Now it is mandatory that a student clears at least 50% of the subjects to become eligible for promotion to the next semester.”