Sunday, August 12, 2018

What is SQL.

 1.  What is Sql.?
Ans: SQL Stands for structure Query Language.
         SQL programming can be effectively used to insert, search, update, delete database records.

2. RDMS:( Relational database management system)

RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM  DB2, Oracle, MySQL, and Microsoft Access.

The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.



        
   

How to use SQL pagination using LIMIT and OFFSET

  How to extract just a portion of a larger result set from a SQL SELECT. LIMIT n is an alternative syntax to the FETCH FIRST n ROWS ONLY. T...