Sql

-- ORACLE SQL - Get the 2 digits at the RIGHT end of a string
SELECT SUBSTR('TN0001234567890345',-2) FROM DUAL;

-- ORACLE SQL - Get the 2 digits at the LEFT end of a string
SELECT SUBSTR('TN0001234567890345',1,2) FROM DUAL;

PREVIOUS	NEXT

Code Example
Sql :: postgresql define pk sequence next number
Sql :: mysql bidirectional composite primary key
Sql :: postgres count distinct
Sql :: mysql subtract month from timestamp
Sql :: Disabling foreign key checks while performing Sqlalchemy Upgrade
Sql :: for loop postgresql
Sql :: how to select department from table
Sql :: mysql between start date and end date
Sql :: t sql remove last character from string
Sql :: mysql full outer join java
Sql :: show all table name mysql
Sql :: how to connect mysql with specify port thorugh cmd
Sql :: sql server user permissions and roles
Sql :: sql count columns
Sql :: sql week commencing date
Sql :: how do you use sql in you company
Sql :: mysql smallint range
Sql :: how to move a columns location in mysql
Sql :: firebase bigquery cloud message
Sql :: copy one column data to another in sql
Sql :: sql fillna
Sql :: string split in sql server
Sql :: mysql trim whitespace
Sql :: mysqldump: couldn
Sql :: mysql update auto
Sql :: centos 8 install mysql
Sql :: mysql pretty date format
Sql :: how to reset table in sql server
Sql :: sql update table based on another table
Sql :: mysql sort by date column