The alter table add column MySQL concept can help to rename a column of any table in the database. In this post, we will use MySQL to run the examples.alter table add column MySQLALTER table ADD … [Read More...]
SQL Tutorial - Welcome to SQLTutorial.net. Let's start learning SQL right away. This is a platform for learning SQL in general. This will help you to learn DBMS concepts, SQL for PLSQL, SQL for Oracle, SQL for Postgre etc.
We have written in such a way that you do not need any prior knowledge. However, to keep it structured and concise, we will provide you respective useful resource links whenever required.
Here are the specialties of this website.
- No prior knowledge required.
- Each topic is having clear syntax and practical examples.
- Diagrams to help you visualize.
- Doubt? Ask us @Comment Section
- Receive the latest updates of new posts on WhatsApp @ +918249410773
SQL NOT EXISTS helps select rows from a table which are not present in another related table (or in the resultset of a subquery).SQL NOT EXISTS OperatorSQL NOT EXISTS return TRUE if the subquery does … [Read More...]
SQL CAST Function helps to modify datatype. e.g. The SQL CAST function can modify or change numeric datatype to character string datatype.SQL CAST Function: Understand casting in SQL with SQL … [Read More...]
SQL EXISTS Operator helps to test the presence of a row based on the related row in a subquery.SQL EXISTS Operator Explained with SQL QueriesSQL EXISTS Operator returns true if the subquery returns … [Read More...]
SQL IN Operator helps to select only those rows which matches at least one out of all values while comparing the column with some values. It basically lets you compare column value against multiple … [Read More...]
SQL NOT IN is an operator which allows checking a column value against some values and restricts rows as filter. If either of the values matches then that row appears in the result-set, then it … [Read More...]
SQL Wildcards or wildcard characters helps to search or filter resultset based on string patterns. These wildcard characters work with SQL LIKE operator in the where clause. SQL Wildcards … [Read More...]
SQL LIKE Keyword by SQL TutorialSQL LIKE KeywordThe SQL LIKE keyword helps to filter based on the specified string pattern in a column.There are a couple of wildcards used to construct the string … [Read More...]
SQL SUM() FunctionThe SQL SUM() Function finds the sum of all the rows of a column. The data inside that column has to be summable. SQL SUM() … [Read More...]
SQL AVG() FunctionThe SQL AVG() function works with a bunch of rows of a column in a table and finds the average of it.SQL AVG() … [Read More...]
SQL COUNT FunctionThe COUNT function returns the number of rows of the resultset. SQL COUNT Syntaxselect count(column_name)from table_namewhere <condition>; or,select count(*)from … [Read More...]
SQL MIN(), MAX() function helps to calculate the minimum or maximum value in a column of a table. Let us see MIN, MAX syntax with examples. What is the SQL MIN Function?The SQL MIN() function returns … [Read More...]
SQL ROWNUM, LIMIT, TOP SyntaxThe SELECT TOP tells the database to return only a certain number or percentage of records. Select TOP is useful when we are querying a large table I.e. … [Read More...]
SQL DELETE query is used to remove a single row, some rows or all from a table. In this SQL Tutorial, we will see the DELETE syntax, examples in details.SQL DELETE SyntaxDELETE all rowsdelete … [Read More...]
SQL Tutorial bringing you SQL Update statements, their usages with practical examples. SQL Update queries help to modify existing data or rows in a table. SQL UPDATE Syntax and example … [Read More...]
SQL Tutorial bringing you the most basic concept on SQL NULL values, their usages with SQL IS NULL and SQL IS NOT NULL clauses. SQL NULL Values Tutorial by SQLTutorial.tips So, what is a … [Read More...]
SQL INSERT INTO QueryINSERT INTO in SQL helps to insert a row or bunch of rows into a table.SQL INSERT INTO SyntaxAll columns have to be in the values section in orderinsert into … [Read More...]
SQL ORDER BYThe SQL ORDER BY helps to sort the result (resultset in terms of database terminology) in either ascending or descending order. Here, ascending is the default sort order. That means if you … [Read More...]
SQL AND, OR, NOT are being useful to apply some logic to conditions in the WHERE clause. This SQL Tutorial will give you tips with syntax on how to use these AND OR NOT operators in SQL to calculate … [Read More...]
SQL WHERE clause acts as a filter to the SQL statements. If the SQL statement is a SELECT query then it fetches those rows which satisfy the conditions in the WHERE clause. Let us say we … [Read More...]
SQL SELECT DISTINCT makes sure that the rows retrieved are distinct by one column or multiple columns.In this SQL Tutorial, we will see syntax and usage of the DISTINCT keyword with various … [Read More...]
SQL SELECT fetches data from database in the form of a set of rows called resultset.SQL SELECT syntaxSELECT columnsFROM tables;Here, the columns can be a single column or multiple or all. If it is a … [Read More...]
SQL Statements are the means to talk with SQL based databases. It may be to fetch some data, delete some data or update something from the database tables. So, basically, SQL statements helps to … [Read More...]
SQL Tables are the primary entity or basic objects in SQL based databases. In this post, we will table about the things you need to know about the SQL database table. Last post we talked about SQL … [Read More...]
SQL is a standard database language. With SQL, one can manage or tweak databases or things inside a database which understand SQL. Imagine you are on an island where nobody speaks English, they … [Read More...]