How to exclude Saturday and Sunday using SQL query

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

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

Very Easy Method SQL Count Consecutive Rows Updated (2021)

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 about 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

What is the cluster in SQL? | Complete Guide 2021

In this article, we will see what is cluster in SQL and what purpose cluster will be created. A cluster in SQL is a database object that stores data related to two are more tables in a single disk space. Single disk space means single memory location that is called blocks. Segments and Memory Locations … Read more