Sql

SELECT RIGHT( '1234567890', 4 ); -- returns '7890'
SELECT SUBSTR( _col_NAME_, LENGTH(_col_NAME_)-3, 4 ); -- string indexing starts from 1

SELECT RIGHT('SQL Tutorial', 1) AS ExtractString;

PREVIOUS	NEXT

Code Example
Sql :: distincct sql
Sql :: oracle pl/sql prevent sql injection
Sql :: prosys sql log
Sql :: async await mysql nodejs
Sql :: how to truncate a table in databse
Sql :: create table with primary key auto increment in sql
Sql :: how to install mysql server on centos 7
Sql :: oracle limit user tablespace
Sql :: default password of mysql
Sql :: sql select contem uma palavra
Sql :: ssh mysql port forwarding
Sql :: plsql code for deleting a row from nested table in oracle
Sql :: mysql update table from select on another table
Sql :: delete all table oracle
Sql :: oracle character set
Sql :: mysql login console
Sql :: mysql select where text contains
Sql :: host is not allowed to connect to this mysql server
Sql :: postgres count string length
Sql :: update row in mysql
Sql :: oracle alter tablespace add datafile autoextend max size
Sql :: mysql alter table set column unique
Sql :: add user mysql
Sql :: MySQL insert into examble
Sql :: check postgresql port windows
Sql :: mysql sort by date column
Sql :: sql insert inserted id
Sql :: print all records of table in mysql
Sql :: select all_source oracle
Sql :: how to delete a record from sqlite in android