The PrettY GeeKs

SQL Queries: Query for getting Second highest number record

2010-10-14T01:43:00.000-07:00

Query for getting Second Highest Number Record from a Table Getting Second highest Marks from tableTwo SQL commands will be used to get the second highest number from the table 1. Order by 2. Limit First we will order the numbers in descending order by using Order By command so that we can get the highest number at the first position(first row) and second highest at the second position(second

SQL Tutorial: Operators

2010-10-13T05:36:00.000-07:00

Operators:Two types of operators1. Comparison Operators2. Logical Operators Comparison Operators: Equal to = Greater Than > Less Than < Greater than or equal to >= Less than or equal to <= Not Equal to <> OR! = BETWEEN between two Values, between an inclusive Range LIKE Search for a character pattern, match a character pattern

SQL Tutorial: Where Clause

2010-10-13T05:15:00.000-07:00

Where---à where clause is used to filter records Explanation:Where clause restricts records that is it helps as to apply conditions on SQL statements to get our desired specific records rather than getting all generalized record Restrict/Limit the returned rows by Where clause Three Elements of WHERE Clause:Column Name Comparison Operator Column Name, Constant, List of Values Example:

SQL Tutorial

2010-09-08T08:04:00.001-07:00

Technical Definition:SQL ----------- Structured Query LanguageSQL is a language that is used to access and manipulate database. Simple Definition:SQL is a language used to create and talk to the database. Explanation:When we create a database it is useless if we can’t do anything with it; electronic database is made for the purpose of making life easy by making information and data centralized

How to Gain Weight: Drink Milk Shakes

2010-08-29T00:46:00.000-07:00

How to Gain Weight: Drink Milk Shakes Many people especially Men has problem of there being so thin. Most of them no matter how much they eat they are unable to gain weight to get some healthy look. In this post i will discuss the most generic tip to gain weight for both Men and Women. The oldest and effective way of gaining weight is drinking Milk shakes. Mango Shake, Straw Berry Shake, Peach

How to Lose Weight: Fast Way of Losing Weight

2010-07-25T08:20:00.000-07:00

Fast way of Losing Weight Most of the people they believe in starving the whole day for losing weight Fast. I also used to do the same. In the end the output is you do lose weight but when you start eating Normal; You revert back to your previous weight. So i have discovered an alternative to strict dieting+starving. When we sleep our body burns the most calories. The best way to lose and to

How to Lose Weight by Drinking Water

2010-06-15T10:57:00.000-07:00

How to Lose Weight by Drinking Water: All of you must have heard of 101 benefits of drinking water. No doubt one of it is Losing weight. When you drink water it dissolves fats in it. Due to which excess amount of fats are expelled out of body with less effort. Most of the people are used to of drinking ice cold water especially in summer season. In fact room temperature water is always

How to lose Weight: Loss Weight by Green Tea

2010-05-10T22:36:00.000-07:00

How to Lose Weight by Green Tea: If you want to loss weight fast then the best way is to start drinking green tea as your loss weight diet. Green Tea is not like Black tea as green tea has no nicotine in it that can put a side effect on your health. Drinking green tea is the healthy way of losing weight. Green tea are only natural herbs that helps you loss weight fast without making your

Hair Tips: Shinning Strong Health and Long Hair

2010-05-04T08:30:00.000-07:00

Hair Tips: Shinning Strong and Long Hair Ingredients:Heena-[In Urdu it is called Mehndi] (Can take an amount sufficient for you hair length and volume)Egg 1Yogurt 3 table spoonGrounded Amla reetha seekakai (These are herbs) 1-2 tablespoon according to your Hair lengthGreen Tea 1 table spoonBlack seeds (kaloongi) 5 to 7 seedsLemon 5-7 drops3 tablespoon of olive oil Procedure: Put 2 table spoon

Hair Tips: Hair Treatment for Thinning Hair and Falling Hair

2010-04-18T07:21:00.000-07:00

Hair Tips: Hair Treatment for Thinning Hair and Falling Hair Ingredients:Desi Ghee (2 to 3 table Spoons according to the length and volume of Hair)Almonds 4 to 8 Pieces Procedure:Take sufficient amount of desi ghee according to your Hair volume and length. Cut 4 to 8 almonds in to small pieces. (4 for short hair and 8 for long hair) Put the almond pieces in the desi ghee in a Container and heat

Farmville: Themes

2010-04-16T00:13:00.000-07:00

Decorating your farm according to different themes is obviously an interesting activity and hence add a different touch to your farm. Here are some snap shots illustrating different themes decoration. Carnival Theme Candy Theme Halloween Theme Shops in garden Cottages Hotel View Santa Clause Workshop

Farmville: Flower Decorations

2010-04-15T07:09:00.000-07:00

Plowing flowers in your farm not only earn you good coins but also enhance beauty of your farm. Here are some snap shots from my farm which can give you some flower decoration ideas for your farm.

Farmville: Decoration Pics

2010-04-14T23:39:00.000-07:00

F for Farm V for Ville FV for Farmville Slow and Steady Wins the Race (Tortoise VS Rabbit) Strawberries and Cherries Farmville Float Herd of Cattle Benches surrounded by Trees School and Library Surrounded by Garden Farm View-1 Farm Full View-2

Farmville: Tips and Tricks

2010-04-12T19:19:00.001-07:00

Farmville offers you coins and FV cash to shop from Market. Coins are easy to earn as when you harvest your crop you earn coins according to the worth of the crop that you plow. On the other hand earning FV cash is a bit hard task as you get an increment of only 1 in FV when you proceed to higher level. Here I will mention some tips for the beginners that will help to speed up the levels. You

Farmville

2010-03-26T12:35:00.000-07:00

I am an addict to Farmville and I am sure I may be having many others who will agree with the same addiction. Everyone playing farmville game has the keen desire to put all devotion in to decorating their farms in a way to get farmville neighbors compliments. Thus, I am uploading some farmville farm decoration pictures to my blog so that beginners or even the advanced players can get some ideas

Art: Welcome Ring

2010-03-25T09:21:00.000-07:00

These are some hand made decoration pieces that i will like to share with you people. Artistic mind people can generate more good ideas with these piece of art. I have posted only four right now but time to time i will post more art work on this page.Creativity Demands to be Shared Welcome Ring: A best decoration piece to be hanged at your room door. It is made up of plastic ring (best approach

Art: Wall Hanging

2010-03-25T09:20:00.000-07:00

Wall Hanging: This decoration piece is one of its own kind. Small diamond shape mirrors enhance its beauty by reflecting light hence creating sparkling effects all over the wall hanging. I have used old-fashioned ever green combination of matching maroon color with white color.

Art: Wall Hanging

2010-03-25T09:17:00.000-07:00

Wall hanging: This piece of decoration is also called as wall hanging in general context but to be more specific it has a funny name that is "Pony Tail" Lolz. Its is made like hair tail as u can also see in the picture above. Moreover it is being decorated by potpourri which is also called as dry arrangement. The dry arrangement stuff is covered with golden shinning spray. Round mirrors and

Art: PhotoFrame

2010-03-25T09:06:00.000-07:00

Photo Frame: I must say its the most tough piece to be made by hands as it is made of katdana (in Urdu) and you can call beats in English. Its very hard to arrange these beat with a needle to accommodate them within drawing boundaries. First I drew the spiral flower art and spiral butterfly art then put glue inside the drawings and the hardest part was to arrange the beats with the shape of

Add Star Ratings to Blogger

2010-03-19T07:53:00.000-07:00

In this tutorial I will like to tell you how to add star ratings to blogger custom templates under each and every Post. 1. Write draft.blogger.com in URL bar and press enter. You will see the following Window 2. Click on Layout 3. Now the following screen will appear. Simply click on Edit 4. A pop-up Window will appear like this. 5. Check "Show Star Ratings (*****)" and Press "Save" Button (

Poetry

2010-03-14T12:35:00.000-07:00

I love you These three words, mean the world to me The smile on your face; The look in your eyes, When you come to me Your endless gaze; Your innocent face, Makes my heart go race.The way you look when you have wrong, The walls of my fortress come crashing down. Then you nestle in my lap, As if there is nothing around My love for you, O dear one! Is so profound. When I look deep into your eyes

Poetry: Justice

2010-03-14T12:29:00.000-07:00

Give me a reason to believe, what I believe. Give me a chance to preach, what I speak. Give me wings to fly, to reach the sky I will rise above and shine down The force of my hand will crush the mighty crown. It is what I feel that drives me to write. Emotions that steer add color to life. Give me will to survive Give me assurance that I am alive I can see, though I am blind I am no different for

Poetry: The Bright Side

2010-03-14T12:25:00.000-07:00

When darkness falls- I find it hard to survive, but I carry on with all my might. A sparkle of hope then revives, when a flash of lightening strikes. When disaster strikes- The pillar of tranquility falls The cries of grief prevail In the streets death strolls And all efforts of man fail Then blessings fall like rain And hope lifts up the veil Life struggles to sustain The ship of humanity sets

Friendship Quote

2010-03-14T11:56:00.001-07:00

To gain the quality of people; put them in to a big Circle then Keep on Decreasing the diameter of the Circle; finally you will get the quality friends. (Author: Pretty Geek, The Pretty Geeks)

Great Quote

2010-03-14T11:41:00.001-07:00

Beware of enemy's friend; because enemy's friend is like a hidden enemy. (Author: Pretty Geek, The Pretty Geeks)