This category is all about SQL interview questions and answers on different SQL concepts such as SQL Functions, Triggers, Commands, comparison concepts like difference between union and union all and difference between unique key and primary key e.t.c.
In this category, we have captured all important SQL concepts with practical examples.
I am sure any beginner can easily understand these concepts.
If you are preparing for an interview, these questions and answers can really boost your knowledge.
Some of them are very frequently asked interview questions such as rank, dense rank, partition e.t.c and some of them are advanced topics.
In this article, We will see how to calculate the gross salary of an employee using plsql program. What is Gross Salary? The workers who are paid for their services are offered gross payment as their CTC ( cost to company). Cost to the company is the quantum that the company will have to dodge … Read more
Here are samples of Oracle SQL queries to exclude Saturday and Sunday using SQL Query. Suppose you’re querying a table to urge the info for a specific date range, and you would like to exclude the weekends. Below is an example. Exclude Weekends in Oracle SQL Using to_char(date, ‘DY’) Function The following SQL query will … Read more
Sum of odd numbers using for loop in pl/SQL. In this article, we will see how to write a PL/SQL program to get the sum of odd numbers using for loop in pl/SQL. Here you can check the query with output. Sum of first odd number = 1 and the Sum of first two odd … Read more
Here are the SQL Date Formats List. You can try yourself and look for the output. These SQL date formats list are useful in your interview point of view and also can be used in your professional SQL work environment depends on your requirements. Select TO_CHAR(date_column, ‘DD-MON-YYYY’) from emp21;Formats:d,dd,dddmm,mon,monthy,yy,yyy,yyyy,year select to_char(sysdate,’dd-mm-yyyy hh:mi:ss’) from dual; Select … Read more
Here is the list of Basic SQL Queries for the beginners. Simple Queries: 1. List all the employee details from the employee table Answer: Select * from employee; 2. List all the department details from the department table Answer: Select * from department; 3. List all job details from job table Answer: Select * from … Read more
In this article, we’ll see the way to count consecutive rows in SQL with practical examples. this is often one of the foremost important and commonly used real-time SQL concepts. I am sure you’ll get a clear picture of this subject so confirm to read this text till the end. At the end of this … Read more
Use of truncate table in SQL Let us see what exactly is that the truncate table in SQL and what’s the utilization of it. At the end of this article, I also captured the video explanation for your better understanding, so confirm to observe that video also. So what’s truncate table in SQL?. In one word It simply removes all the rows from a table. The syntax for truncate … Read more
In this article, we will see what is sub query in SQL and its use. Also we will write simple sub queries with practical examples. In simple words a sub query is nothing but a query inside query. Many times you would like to have a series of SQL chained where an output of one … Read more