Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql remove last 2 digit

SELECT LEFT([columnName], LEN([columnName]) - 2) EditedColumn
FROM   [TABLE]
Comment

PREVIOUS NEXT
Code Example
Sql :: sql first character 
Sql :: mysql ifnull 
Sql :: mysql url 
Sql :: change default schema sql server 
Sql :: create table in mysql 
Sql :: oracle sql listagg 
Sql :: change role postgres 
Sql :: MYSQL select last query 
Sql :: sql select sum group by id laravel 
Sql :: insert output identity 
Sql :: sql distinct with count 
Sql :: count characters of string mysql 
Sql :: postgres check for foreign key 
Sql :: postgres set column based on another column 
Sql :: show all tables postgres 
Sql :: postgres create extension if not exists 
Sql :: mysql update with subquery 
Sql :: run sql file in terminal 
Sql :: update query in sql server 
Sql :: sql get the name of user pc 
Sql :: create database sql 
Sql :: mysql update join 
Sql :: mysql count number of occurrences in a column 
Sql :: write sql query to find the second highest salary of employee 
Sql :: convert varchar column to int in sql server 
Sql :: create table split string function in sql server 
Sql :: rename a table in sql server 
Sql :: null sql 
Sql :: primary key multiple 
Sql :: oracle drop sequence if exists 
ADD CONTENT
Topic
Content
Source link
Name
5+5 =