• Arun Kumar

SQL query between dates

To query a date column between specific dates, use below query

select count(*) from DW.TB_PCDWH0091_FCT_PROJ_DTL
 where dw_load_dt between 
to_date('2016-09-01', 'YYYY-MM-DD HH24:MI:SS') and
to_date('2016-10-31', 'YYYY-MM-DD HH24:MI:SS'); 

122 views

Recent Posts

See All

Hotel Booking Application SQL Project

The goal of this project is to test your SQL skills. You would need to use both technical and analytical skills to solve this project. Before you start, you must have CREATE TABLE, INSERT TABLE privil

Oracle Joins

When you normalize data and create tables inside the database, the data is scattered into different tables. In order to create meaningful data, we must query data by joining multiple tables. Setup tab