Database Star: Home
open-menu closeme
Home
Start Here
About
Contact
Shop
youtube twitter linkedin github
  • SQL MIN Function with Examples

    calendar Jan 21, 2021 · 6 min read · sql-functions  ·
    Share on: twitter facebook linkedin copy

    The SQL MIN function is used to find the lowest or minimum value. Learn how to use it and see some examples in this article.


    Read More
  • SQL Aggregate Functions: A Guide

    calendar Jan 12, 2021 · 12 min read · sql-functions  ·
    Share on: twitter facebook linkedin copy

    Learn all about SQL aggregate functions and what they do in this article.


    Read More
  • SQL AVG Function with Examples

    calendar Jan 12, 2021 · 5 min read · sql-functions  ·
    Share on: twitter facebook linkedin copy

    The SQL AVG function allows you to find the average value from the specified values. Learn how to use it and see some examples in this article.


    Read More
  • SQL MAX Function Explained with Examples

    calendar Jan 10, 2021 · 5 min read · sql-functions  ·
    Share on: twitter facebook linkedin copy

    Learn how to use the SQL MAX function.


    Read More
  • SQL SUM Function Explained with Examples

    calendar Jan 7, 2021 · 6 min read · sql-functions  ·
    Share on: twitter facebook linkedin copy

    The SQL SUM function can be used to add numbers together. Learn how to use it and see some examples in this article.


    Read More
  • SQL CAST Function Explained with Examples

    calendar Apr 30, 2020 · 7 min read · sql-functions  ·
    Share on: twitter facebook linkedin copy

    The SQL CAST function is quite powerful, but it can be hard to use. Learn how to use it and what it can do in this article.


    Read More
  • SQL COUNT Function Explained with Examples

    calendar Jan 5, 2020 · 7 min read · mysql oracle postgresql sql-functions sql-server  ·
    Share on: twitter facebook linkedin copy

    The SQL COUNT function is one of the most common functions used by SQL developers. I use it on a daily basis. Learn more about the COUNT function in this article.


    Read More
  • SQL CASE Statement Explained with Examples

    calendar Jan 4, 2020 · 12 min read · mysql oracle postgresql sql-functions sql-server  ·
    Share on: twitter facebook linkedin copy

    The SQL CASE statement allows you to perform IF-THEN-ELSE functionality within an SQL statement. Learn more about this powerful statement in this article.


    Read More
  • A Guide to SQL NULL (and SQL NOT NULL)

    calendar Dec 23, 2019 · 12 min read · sql sql-functions  ·
    Share on: twitter facebook linkedin copy

    In this article, you'll learn all about NULL, what it is, why it's different, how you can check for it in different databases, and many examples.


    Read More
  • SQL UPPER, LOWER, and INITCAP Function Guide, FAQ & Examples

    calendar Jan 6, 2018 · 8 min read · sql-functions  ·
    Share on: twitter facebook linkedin copy

    Changing the case of text in SQL is a common task when comparing strings or validating data. Learn how to do it with the UPPER, LOWER, and INITCAP functions in this article.


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • 5
    • »
    • »»

Ben Brumm

Improve your database and SQL skills.
Read More

Recent Posts

  • dbForge SQL Complete 7.0 Just Released
  • I Surveyed 483 SQL Users About Their Tools
  • How to Delete a Row in SQL
  • How to Count Distinct Values in SQL
  • How to Install Postgres on Mac Using Homebrew
  • Solution for Homebrew PostgreSQL Service Not Starting
  • How to Install MySQL on Windows
  • How to Install Postgres on Windows

Categories

ALLVENDORS 78 ORACLE 67 MYSQL 11 SQLDEVELOPER 9 SQLSERVER 5 POSTGRES 3 NOBANNER 1

Tags

SQL 63 SQL-FUNCTIONS 56 SQL-ERRORS 22 SQL-SERVER 14 MYSQL 12 ORACLE 12 POSTGRESQL 12 WORK-PERFORMANCE 11 DATABASE-DESIGN 9 CAREER-PLAN 5 PROGRAMMING 5 JOB-SEARCH 3 TOOLS 2
Database Star: Home

Copyright  DATABASE STAR: HOME. All Rights Reserved

to-top