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
Wednesday, March 23, 2011
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
•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
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-Bangalore
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.
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.
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
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)
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.”
“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.”
Subscribe to:
Posts (Atom)
