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.
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.
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.
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.
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.
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.
What are JOINs in SQL? JOINs in SQL are feature by which we combine rows of two SQL tables through …
What is a Select Statement for SQL? SELECT statement for SQL, sometimes referred to as a Query, allows you to …
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 Read More »
