How to rank in SQL
In this blog, we will understand how to rank in SQL your data. We will first understand what is SQL rank function then dense_rank SQL. Then also understand row number SQL. We will first create SQL table and then insert our data to understand these three functions in SQL i.e. rank function SQL, oracle dense_rank, oracle row_number.
How to use row_number in SQL | SQL RANK() function | dense_rank SQL Read More »
INDEX in SQL
Index in SQL is the most powerful and useful aspect of SQL. It helps in improving the performance of database queries and provides direct and fast access to database rows. The users can’t see indexes they are just used to speed up searches and queries.
Index in SQL | What is Index in SQL | How to create Index in SQL Read More »
oracle case statement
The SQL CASE statement is a logical statement that helps in putting values based on logical arguments. The CASE statement goes through conditions and returns a value when the first condition is met. So, once a condition is true, it will stop reading and return the result. If no conditions are true, it returns the value in the ELSE clause. If no conditions meet the criteria then NULL value will return.
Oracle CASE statement || SQL CASE statement with 2 Example Read More »
What is View in SQL
View in SQL is a virtual table that is basically a SQL dynamic table. It is created by SQL query and used for quick reference as carrying a long query in SQL is difficult, so we store it in the view as per our comfort.
What is View in SQL || 2 ways to create view SQL Read More »
Group by SQL function
Group by in SQL is a function by which we are grouping column values against record groups. It helps in aggregating columns data and getting summary of values. Group by SQL function is a very useful and frequently used SQL function.
The GROUP BY clause groups records into summary rows.
GROUP BY returns one record for each group.
GROUP BY is used with aggregates like COUNT, MAX, SUM, SUM and AVERAGE.
Group by SQL function || Group by in SQL with examples Read More »
What is Pivot and Unpivot in SQL
In this article, we will learn about Pivoting and unpivoting data in SQL. But before how to do Pivot and Unpivot in SQL we must understand what is pivot and unpivot in SQL. In SQL Oracle, Pivot and Unpivot are relational operators that are used to transform one SQL table into another SQL table in order to achieve a simpler view of the data. In simple terms, we can say that SQL Pivot operator converts the unique values from one column values which are in rows into different columns. Basically, it convert rows to columns in SQL. The SQL Unpivot operator does the opposite that is it transforms the different columns into rows identified by these unique columns name in a new column.
Pivot and Unpivot in SQL || How to convert rows to Columns in sql Read More »
What are JOINs in SQL? JOINs in SQL are feature by which we combine rows of two SQL tables through
JOINs in SQL | How to JOIN two tables in SQL Read More »
What is a Select Statement for SQL? SELECT statement for SQL, sometimes referred to as a Query, allows you to
SELECT statement for SQL Read More »
Insert query in SQL Introduction to Oracle INSERT statement In our previous post, we learned about how to create a table in
Insert query in SQL | SQL insert statement in Oracle Read More »
How to create a table in SQL In this tutorial, we will learn how to create a table in SQL.
How to create a table in SQL | SQL tutorial for beginners |SQL create table by Read More »