shining world

Finding The nth maximum or minimum...from a table using sql query

2012-02-02T22:11:00.000-08:00

table T(name varchar,marks number)
select t1.name,t1.marks from T t1 where
n= ( select count(distinct marks) from T t2 where t1.marks <= t2.marks order by marks desc )

and for finding nth minimum we just need to reverse the where condition in inner query

select t1.name,t1.marks from T t1 where
n= ( select count(distinct marks) from T t2 where t1.marks >= t2.marks order by marks desc )

Go Green and Go Green and Go Green........

2011-12-29T22:42:00.000-08:00

There are so many ways by which we can save energy if we want,through this article i want to give people some examples that where we can save energy though there are lots of example........

1 .Use of public transport,passengers buses means don't use personal vehicles as much as possible and this can be achieved when this facility is improved. and walk instead of using bike or car wherever possible

2. market is flood with cars and two wheeler (motor bikes) so to discourage people from use of these , they should be charged more in parking and bicycles should not be charged at all

3. Internet and mobile is being used widely so we should use the concept e-X i.e. e-banking,e-invitation,e-ticket,e-commerce,e-mail which saves lots of paper and hence trees .recently, IRCTC allowed the passengers to show snapshot of e-ticket either on laptop,palmtop,mobile that saves 3-lakh paper per day

4.Roof of big buildings and buses can be used for plantation

even not only for plantation buildings roof can also be used for installing solar energy equipment like solar heater,solar panel etc.

5. In big halls,cinemas etc. on electric board there should be one to one mapping between switch and appliance attached with that switch so people need not to switch on all switches when he needs only one button to switch on.

6.Recycling concept can lead the things to last for long time.in country like india crores of population is living far bellow powerty line and they don't have clothes to wear so instead of throwing your clothes you can give to these people.and you can fulfill their dream that they are dreaming in their life.

it's not confined upto only clothes there are other things also those can be recycled.

these people strive for food through out their life so waste food that you have daily at your home ,you can give it to these people.

Court Ordered Social Networking Sites to remove "anti-social and anti-religious" content from their websites

2011-12-25T02:47:00.000-08:00

Court has given ultimatum to 22 social networking sites ( SNS ) to remove anti-religion and anti-social content or images from their websites till february 6,2012.
anti-religion content or image means which hurts sentiment of other religion's people.so after this move you can not condemn other people or religion on SNS so easily.and these social networking sites has to provide a solution that either anti social content can't be written or can be removed form the site.

Now these sites owner have to think whether which image is anti-social or not. an image can tell everything or nothing depending upon how much you thing or don't think.so this seems to be a tough task for these sites.

Value of Bharat Ratna award is getting Decreased

2011-12-23T02:32:00.000-08:00

I am writing this post after seeing many recommendations for Bhart ratna award,and now govt has changed rule and made sports player elligible to receive Bharat Ratna award.as soon as govt included this category,home ministry received so many requests from different fields of sports for bharat ratna
1.sachin tendulkar
2.Major Dhyanchand
3.Abhinav Bindra
4.Vishwanathan Anand
5.Saina nehwal
6.paes and Bhupati

If people are requesting like this and if they are granted then one day Bharat Ratna award would have lost it's value and then receipent would not feel any proud after bagging this prestigous award.
Today home ministry have included sports next time it may include other category and if it goes on adding new categories in the list of Bharat Ratna in which it goes.and in this way it may lose its pride that it has got.

redtube, pandora, limewire

Indian colleges are loosing their orientation

2011-11-30T00:21:00.000-08:00

Indian B-schools and Engineering colleges are not imparting to the students what is required to them but they are trying to get placement figures up.By keeping in mind today's scenario that how the world is suffering from different problems like technical,india loosing market reputation and slowdown,these colleges should impart knowlege oriented,problem oriented study instead of placement hence these students can solve these problems before they happens.
When we see slowdown like in Europe,USA can't we provide them better solution to beat these problem and hence creating a good image in from of them.

Foreign Retail Investors are in Indian Retail market

2011-11-28T23:33:00.000-08:00

Govt in parliament decided to allow 100% foreign direct investment(FDI) in single brand retail and 51% FDI in multibrand retail.

study tells that it will bring 1 million direct jobs and 6 millions indirect jobs.these retial investors will open their stores in the cities with population above 1 million hence 51 cities have qualified for this.and out of these 51 cities 23 cities are opposing these FDI in multi brand and single brand retails.

Now the question is that what will happen to kirana shopkeepers and domestic traders.whether they will also get advantage of this FDI or they will be hurted.but sure this FDI will increase competition in retail market and hence customer will get quality products and better services otherwise these investors will not be able to survive in the market.

mcafee, pandora, limewire

Govt is trying to ban smoking scene being shown in movies...............

2011-11-28T04:29:00.000-08:00

Kaitrina kaif is smoking in
Mere brother ki dulhan movie.
although it is her character in the movie but still it should not be shown in the movies that promotes people towards doing smoking...when the same actress is doing some ads of some product then people will buy that product as it is advertised by their favorite heroine..so why not they can start doing smoking....until and unless people are aware of causes of smoking.....
So govt is trying to ban this kind of scene being shown in the movie.
but may be it is the need of script.even then also they should change their script
hence it can't promote people towards wrong doing.
we have many more movies in which this kind of scene were shown like guzarish,devdaas etc.instead of showing it like this,they should show it in such a way that people don't get promoted towards it.

Durban meeting for setting enviornmental goals

2011-11-28T04:07:00.000-08:00

Different countries from the world will participate in this meeting for curbing pollution.and these country will sign for kyoto protocol agreement since it is going to end by 2012.but US the developed country which is not under kyoto protocol is hardly going to sign.

In this meeting they should increase carbon credit that's why countries can be promoted towards not emitting much carbon.

ADDICTION OF FACEBOOK.....

2011-10-12T03:23:00.000-07:00

every thing has two sides,just like a coin.now a days you can see that the young generation is so addicted of facebook that they can pass their hours of hours....even i have seen many people doing chat on facebook for whole night....whatever it is wasting of time or entertainment...but it's too much so if the young generation can convert this whole chatting on facebook into a discussion....(though it's there but very less) ,idea sharing,logical thinking etc than it will be very fruitful.
at the end i am not opposing that people should not do chatting, but it should have some limit.for example they keep fb logged in and when they are doing some office work or any work that require some attention it disturbs..as and when they get some message although there are some options to set your profile like busy,don't disturb....but still if some message comes in your account you can't avoid it from reading.

MESSAGE FOR DIWALI

2011-10-07T00:10:00.000-07:00

my hearty requests to my dear and near....

1. keep your self away from crackers and don't allow children to burn crackers it can cause an accident (थोड़ी देर का मजा फिर जिन्दगी भर की सजा ).

2. burning the crackers increases noise pollution,air pollution so
3. just think about the people who are suffering of asthma...they never hope for the diwali to be celebrated as burning crackers (aawaj wali diwali).
4. you can celebrate by distributing sweets,wearing new new clothes ,i mean to say is that don't do the things that is harmful for others...
5.just think if every 10th person in our country don't burn crackers then calculate for our 1 billion population(apprx.) what u can save..
   a.first of all lots of paper can be saved.. i.e. saving the enviornment

   b.noise and air pollution gets reduces with a large factor with compare   to what it could have been these days (around diwali)

c.money saved from these crackers can be used for your other work or enjoyment(celebrate diwali with sweets,buy other things on this occasion).

Resource wastage in Education System

2010-03-28T22:01:00.000-07:00

Indian education system is such that we are not utilising resources proprely
for example due to privatization govt. is investing money in govt. colleges,schools and thus students studying in these colleges and schools are not paying attention in the class itself and consequently they need to have private coaching or tutors.

More over if i consider the case that govt is providing scholarship to the children of the family having bad economic conditions. but are they using this scholarship for their education improvement??? no. most of the students are using this scholarship for their needs and other things needed in house. so rather than giving scholarship to those children , government should provide study material,copy,traveling facilities.

If i take the case of level of education given to the students is not upto the level that is needed. i mean they are not given the actual education needed in industry,organisation etc.. so they need to have seperate training for the same.

How can we save enviornment

2010-03-16T09:37:00.000-07:00

All human being are leaving some carbon footprint on this earth and it is increasing very drastically.it may lead to increase in temperature to 2 degree
Celsius by 2050.and its result will be very disastrous to all us. so commit from now onward that i will be contributing to save the environment.you can save it via the following ways.........

1.for short distance ( i.e. 1 or 2 km.) traveling do not use personal vehicle. you can use public transport or can walk for this much distance.

2.use envelope received with greetings,admit cards and other posted documents etc........

3.do not take unnecessary receipts from ATM machine and use internet banking,e-ticket reservation.

4.At traffic signal put off your bike or car if there is wait of 30 seconds or more.

5.use ventilation in offices,house that can save electricity used in day time.

Success or Failure

2009-12-18T10:38:00.000-08:00

I think that we should not loose our confidence by failure or should not be over confident that i will not fail .if we get failure anywhere in the life we should find causes of failure and again start to fight is back rather than going away from this competition.

A successful person is that who always looks for success rather than seeing back.if once he has started doing work he never think about failure. but it does not mean that successor underestimate the looser.