Posts tagged "SQL "

Tag Archives: SQL

Create Table in SQL

The CREATE TABLE statement is used to create a table in a database. While creating the Table, you must specify the Table Name, Column Names, column Data Types and column size.   SQL Syntax : CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), column_name3 data_type(size), …. );   The column_name parameters specify the names of the columns … Continue reading Create Table in SQL

Single Row Function in SQL

Let’s understand the Single Row Function in SQL. First, understand, What is Function? A function is something which accepts the arguments perform an operation on these arguments and produce the result.   In SQL, We have two type functions. Single-Row Function – Which returns one result per row. I.e accepts one row as arguments and … Continue reading Single Row Function in SQL