Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to get previous year from sysdate in oracle

SELECT extract(YEAR FROM sysdate) - 1 AS PREVIOUS_YEAR FROM DUAL;
Comment

PREVIOUS NEXT
Code Example
Sql :: sql string function update replace 
Sql :: add foreign key to existing table postgres 
Sql :: python mysql create table if not exists 
Sql :: union vs intersect sql 
Sql :: SQL Subquery and JOIN 
Sql :: not regexp_like in oracle 
Sql :: auto increment column in mysql query results 
Sql :: sql practice 
Sql :: sql select non unique 
Sql :: sql values to array of objects 
Sql :: get locked tables sql server 
Sql :: how to install mysql 8.0 windows service 
Sql :: docker add mysql to image 
Sql :: mysql count unique in group statement 
Sql :: SQL print multiple variable 
Sql :: get all employee of salary if more than in sql 
Sql :: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 
Sql :: linux bash run sql command 
Sql :: influxdb delete measurement based on date 
Sql :: oracle pl/sql package 
Sql :: mysql command prompt date insert format 
Sql :: sql join on a subquery 
Sql :: oracle alter table add column 
Sql :: sql insert data 
Sql :: to show sp in sql server 
Sql :: mysql size of database 
Sql :: sql server set default value equal to auto increment 
Sql :: postgres full text search example 
Sql :: sql table 
Sql :: How do I UPDATE from a SELECT in SQL Server? 
ADD CONTENT
Topic
Content
Source link
Name
5+9 =