BeginnersBook

  • Home
  • Java
    • Java OOPs
    • Java Collections
    • Java Examples
  • C
    • C Examples
  • C++
    • C++ Examples
  • DBMS
  • Computer Network
  • Python
    • Python Examples
  • More…
    • jQuery
    • Kotlin
    • WordPress
    • SEO
    • JSON
    • JSP
    • JSTL
    • Servlet
    • MongoDB
    • XML
    • Perl

SQL Rename Database using ALTER DATABASE Statement

Last Updated: August 15, 2022 by Chaitanya Singh | Filed Under: SQL

You can rename a database using ALTER DATABASE statement. Limitations and restrictions of renaming a database 1. Database cannot be renamed to an existing database… [Read More]

SQL Data Types

Last Updated: July 12, 2022 by Chaitanya Singh | Filed Under: SQL

SQL Data type defines the values that a column can accept, for example if a column of the table has an int data type, then… [Read More]

SQL Tutorial for Beginners: Learn SQL

Last Updated: July 12, 2022 by Chaitanya Singh | Filed Under: SQL

This SQL tutorial is design for beginners as well as advanced professionals. Each tutorial is started from basic level so a SQL beginner will be… [Read More]

SQL SELECT AVG() Function

Last Updated: December 10, 2018 by Chaitanya Singh | Filed Under: SQL

SQL AVG() function returns the average of values of a numeric column in a table. AVG() Syntax SELECT AVG(column_name) FROM table_name WHERE condition; SQL AVG()… [Read More]

SQL SELECT SUM() Function

Last Updated: December 10, 2018 by Chaitanya Singh | Filed Under: SQL

SQL SUM() function returns the total sum of values of a numeric column in a table. SUM() function Syntax SELECT SUM(column_name) FROM table_name WHERE condition;… [Read More]

SQL SELECT MIN, MAX Functions

Last Updated: December 2, 2018 by Chaitanya Singh | Filed Under: SQL

SQL MIN() & MAX() functions are used to find the lowest value and largest value of a column respectively. MIN(column_name): It returns the lowest value… [Read More]

SQL DELETE Statement

Last Updated: December 2, 2018 by Chaitanya Singh | Filed Under: SQL

SQL DELETE statement is used to permanently delete existing records (rows) from the table. This statement can be used to delete one or more records… [Read More]

SQL UPDATE Statement

Last Updated: December 2, 2018 by Chaitanya Singh | Filed Under: SQL

The UPDATE statement in SQL is used to update records in the table. We can modify one or multiple records (rows) in table using UPDATE… [Read More]

SQL NULL Check in Where clause – IS NULL and IS NOT NULL

Last Updated: December 2, 2018 by Chaitanya Singh | Filed Under: SQL

In SQL Where clause tutorial, we learned how to use comparison operators such as =, <, > etc in where clause for conditions. However when… [Read More]

SQL SELECT AS – Alias in SQL

Last Updated: December 2, 2018 by Chaitanya Singh | Filed Under: SQL

SQL SELECT AS is used to assign temporary names to table or column name or both. This is known as creating Alias in SQL. In… [Read More]

SQL Select Random Rows from Table

Last Updated: November 29, 2018 by Chaitanya Singh | Filed Under: SQL

Sometimes there is a need to fetch random record from the table. For example – You have a list of quotes stored in a table… [Read More]

SQL INSERT INTO SELECT Statement

Last Updated: November 29, 2018 by Chaitanya Singh | Filed Under: SQL

In the previous tutorial, we learned the SQL INSERT INTO statement. In this guide, we will see a useful variation SQL INSERT INTO SELECT statement… [Read More]

SQL INSERT INTO Statement

Last Updated: November 29, 2018 by Chaitanya Singh | Filed Under: SQL

The SQL INSERT INTO statement is used to add new records (rows) in the table. While adding a record in the table, it is not… [Read More]

SQL – Combining AND, OR and NOT together in where clause

Last Updated: November 28, 2018 by Chaitanya Singh | Filed Under: SQL

In the last tutorial, we learned how to use logical operators AND, OR and NOT in SQL where clause. In this guide, we will learn… [Read More]

SQL AND, OR and NOT Operators with examples

Last Updated: November 28, 2018 by Chaitanya Singh | Filed Under: SQL

In the last tutorial, we learned how to use where clause in an SQL statement. In this guide, we will learn about logical operators AND… [Read More]

  • 1
  • 2
  • 3
  • Next Page »

SQL Tutorial

  • SQL Tutorial
  • SQL Introduction
  • SQL Syntax
  • SQL Data Types

SQL Database

  • SQL CREATE DB
  • SQL DROP DB
  • SQL Rename DB
  • SQL USE DB

SQL Queries

  • SQL Select
  • SQL Select Distinct
  • SQL Select Count
  • SQL Select Top
  • SQL Where
  • SQL AND, OR & NOT
  • SQL Order By
  • SQL Insert Into
  • SQL Insert Into SELECT
  • SQL Select Random
  • SQL Alias
  • SQL NULL Check
  • SQL Update
  • SQL Delete
  • SQL MIN, MAX
  • SQL SUM
  • SQL AVG

Copyright © 2012 – 2025 BeginnersBook . Privacy Policy . Sitemap