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...