Pretty Geeks

Query for getting Second Highest Number Record from a Table Getting Second highest Marks from table Two SQL commands will be used to get the second highest number from the table 1. Order by 2. Limit

Operators: Two types of operators 1.    Comparison Operators 2.    Logical Operators

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

Technical Definition: SQL ----------- Structured Query Language SQL 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 and getting standard information in the form of related records from database in niche of time. SQL is a language that is made to create and communicate with the database that is through that language we can not only create our database but further on we can operate the already developed database in the way we want; most probably useful way. When we make a database especially relational database we made tables with related data in them. We can feel the need to add data, delete data, update data and obviously access data from those tables. SQL database . gives you privileg...

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 need specific value of XP to move up in Farmville. In order to gain XP you need to plow land and crops abundantly. If you are frequent user of face book then plow crops that can grow in fewer hours because when you plow crops again and again it will earn you more and more XP. 1Xp for plowing each plow square and 1 XP for plowing crop in each plow square. If you are doing Job or Busy student then plow crops with more XP and maximum growing time; presently Farmville gives crops that gain you maximum of 2XP for each plow square in earlier levels and few crops that yield you 3XP for each plow squar...

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

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 )

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

Playing chess is better approach as compared to playing politics in ones life. (Author: Pretty Geek , The Pretty Geeks )

Speak less Listen more Sleep less Think more (Author: Pretty Geek , The Pretty Geeks )

Sincerity is the backbone of good relationship. (Author: Pretty Geek , The Pretty Geeks )

Stars can only Shine at Night; Try to Glitter like a Diamond. (Author: Pretty Geek , The Pretty Geeks )

If Majority is against you then doesn’t matter because Good people lies in Minority. (Author: Pretty Geek , The Pretty Geeks )

Perception is the Back Bone of Personality. (Author: Pretty Geek , The Pretty Geeks )

No Man and No Woman can change the Society but Both can. (Author: Pretty Geek , The Pretty Geeks )

There are three types of people in the World First Type: These people do work that benefits them Second Type: These people do work that benefits them but harm others. Third Type: These people do work that do no benefit to them but harm others (Author: Pretty Geek , The Pretty Geeks )

Love to Learn and Learn to Live. (Author: Pretty Geek , The Pretty Geeks )

Your Words will become important to others if you make yourself important to others. (Author: Pretty Geek , The Pretty Geeks )

To think is the Thinking of Thinkers. (Author: Pretty Geek , The Pretty Geeks )

If you want to be a successful Personality then make your attitude kind but rules strict. (Author: Pretty Geek , The Pretty Geeks )