SQL Date Formats List Updated(2020)

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

Basic SQL Queries Updated (2020)

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

Very Easy Method SQL Count Consecutive Rows Updated (2022)

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

What is the Use of a truncate table in SQL? Updated 2021

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

How to Write Simple Subqueries in SQL?

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