Skip to content

SQL Tutorial

SQLTutorial.net – Learn SQL

  • Home
  • Data types
  • Statements
    • DDL statements
    • DML statements
    • TCL statements
  • Functions
    • Aggregate Functions
    • DATE Functions
    • String Functions
    • Ranking Functions
    • Analytical Functions
    • Window Functions
    • Math Functions
  • Operators

Category: SQL

SQL Tutorial – Learn sql language

Create table

SQL CREATE TABLE is a statement that is used to create a new table in a database. A table is a collection of data that is organized in rows and columns, similar to a spreadsheet. Each column represents a specific data type, while each row represents a unique record in the table. Syntax The basic…(Continue Reading)

Posts pagination

Previous 1 … 22 23

SQL Tutorial

  • JSON Querying and Extracting Values
  • Table variables
  • Temporary Tables
  • RETURN
  • CONTINUE
  • BREAK
  • WHILE Loops
  • STRING_SPLIT
  • How to Make a Search Query That Contains Each Word of a String
  • SQL interview questions with answers
  • How to find if a foreign key exists
  • Select in Where clause
  • Having vs Where clause
  • IF ELSE Statement
  • Parse Text to JSON
  • FOR JSON clause
  • OPENJSON function
  • ISJSON function
  • JSON_MODIFY function
  • JSON_QUERY function
  • JSON_VALUE function
  • SQL Server JSON
  • SQL convert to lowercase
  • SQL clustered vs non clustered index
  • SQL Truncate Table vs Delete
  • SQL alter type of column
  • Find duplicates SQL Query
  • DATETIMEOFFSET
  • SMALLDATETIME
  • SQL compare date
  • SQL query update table
  • Concatenation in SQL query
  • EOMONTH
  • Weekday function
  • Get first day of month
  • Multiple WHERE Conditions in SQL Server
  • SQL Stored Routines
  • SQL cast as integer
  • Understanding Foreign Keys
  • SQL queries
Copyright 2018 - 2026 | Privacy Policy
↑