GROUP BY in SQL

Date Published: 19/07/2020Published By: JaiSchool

GROUP BY clause is used to display strings (data) which is duplicate in a column. For example, if in an […]

0 CommentsRead More

Data Sorting in SQL: Ascending & Descending Order

Date Published: 14/03/2020Published By: JaiSchool

When we want to display data in ascending or descending order, we use SORT BY in the SQL query. Use […]

0 CommentsRead More

SQL Select Query

Date Published: 13/03/2020Published By: JaiSchool

Select query in the SQL (structured query language) is used to display data from the table. Query – SELECT * […]

0 CommentsRead More

How To Add Column in a Table in SQL

Date Published: 12/03/2020Published By: JaiSchool

Today, we are going to learn how to add a column in a table using SQL (structured query language). The […]

0 CommentsRead More

How to Delete A Column in SQL?

Date Published: 11/03/2020Published By: JaiSchool

ALTER TABLE table DROP COLUMN column query is used to delete a column in SQL. And to remove multiple columns […]

0 CommentsRead More

How To Delete Data (Rows & Columns) From A Table in SQL

Date Published: 10/03/2020Published By: JaiSchool

In this guide, you are going to know how to empty a table in SQL or delete all the data […]

0 CommentsRead More

How To Update Data in Table in SQL

Date Published: 06/03/2020Published By: JaiSchool

In this SQL (structured query language) guide, you will be aware of how to update the data in the column […]

0 CommentsRead More

How To Delete Table in SQL (Single or Multiple)

Date Published: 05/03/2020Published By: JaiSchool

To delete a table from the database, run query in Mysql code editor DROP TABLE table_name; Make sure you have […]

0 CommentsRead More

How To Delete Database in SQL

Date Published: 04/03/2020Published By: JaiSchool

In this informative guide, you will know how to delete a database using SQL in any RDBMS program like Mysql. […]

0 CommentsRead More

How To Store/Insert Data in Columns of a Table Using SQL

Date Published: 02/03/2020Published By: JaiSchool

Today, in this guide, you will know how to insert data in the columns of a table. We are going […]

0 CommentsRead More