Skip to content
Adglob Infosystem Pvt Ltd
  • About Us
  • B2B and B2C Database
  • Bulk Email Solution
  • Contact Us
  • Corporate Email Service
  • Database Portfolio
  • Database Process Flow
  • Database Services
  • FAQs
  • Lead Generation
  • Managed Email Campaign Solution
  • Our Clients
  • Privacy Policy
  • Product Blog
  • Request Sample for Free Database
  • Terms & Conditions
  • Web Scrapping
  • SQL

    1. Home>
    2. SQL>
    3. Page 2

    SQL – Handling Duplicates

    • Post author:S J
    • Post published:August 18, 2021
    • Post category:SQL
    • Post comments:0 Comments

    There may be a situation when you have multiple duplicate records in a table. While fetching such records, it makes more sense to fetch only unique records instead of fetching…

    Continue ReadingSQL – Handling Duplicates

    SQL – Using Sequences

    • Post author:S J
    • Post published:August 18, 2021
    • Post category:SQL
    • Post comments:0 Comments

    A sequence is a set of integers 1, 2, 3, ... that are generated in order on demand. Sequences are frequently used in databases because many applications require each row…

    Continue ReadingSQL – Using Sequences

    SQL – Sub Queries

    • Post author:S J
    • Post published:August 18, 2021
    • Post category:SQL
    • Post comments:1 Comment

    A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within the WHERE clause. A subquery is used to return data that…

    Continue ReadingSQL – Sub Queries

    SQL – Clone Tables

    • Post author:S J
    • Post published:August 18, 2021
    • Post category:SQL
    • Post comments:0 Comments

    There may be a situation when you need an exact copy of a table and the CREATE TABLE ... or the SELECT... commands does not suit your purposes because the…

    Continue ReadingSQL – Clone Tables

    SQL – Temporary Tables

    • Post author:S J
    • Post published:August 18, 2021
    • Post category:SQL
    • Post comments:0 Comments

    What are Temporary Tables? There are RDBMS, which support temporary tables. Temporary Tables are a great feature that lets you store and process intermediate results by using the same selection, update, and…

    Continue ReadingSQL – Temporary Tables

    SQL – Date Functions

    • Post author:S J
    • Post published:August 18, 2021
    • Post category:SQL
    • Post comments:0 Comments

    The following table has a list of all the important Date and Time related functions available through SQL. There are various other functions supported by your RDBMS. The given list…

    Continue ReadingSQL – Date Functions

    SQL – Wildcard Operators

    • Post author:S J
    • Post published:August 18, 2021
    • Post category:SQL
    • Post comments:0 Comments

    We have already discussed about the SQL LIKE operator, which is used to compare a value to similar values using the wildcard operators. SQL supports two wildcard operators in conjunction…

    Continue ReadingSQL – Wildcard Operators

    SQL – Transactions

    • Post author:S J
    • Post published:August 18, 2021
    • Post category:SQL
    • Post comments:0 Comments

    A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion…

    Continue ReadingSQL – Transactions

    SQL – Having Clause

    • Post author:S J
    • Post published:August 18, 2021
    • Post category:SQL
    • Post comments:0 Comments

    The HAVING Clause enables you to specify conditions that filter which group results appear in the results. The WHERE clause places conditions on the selected columns, whereas the HAVING clause places conditions…

    Continue ReadingSQL – Having Clause

    SQL – Using Views

    • Post author:S J
    • Post published:August 18, 2021
    • Post category:SQL
    • Post comments:0 Comments

    A view is nothing more than a SQL statement that is stored in the database with an associated name. A view is actually a composition of a table in the…

    Continue ReadingSQL – Using Views
    • Go to the previous page
    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • Go to the next page
    Copyright - OceanWP Theme by OceanWP