Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sort by last three charecter in sql

select Name from STUDENTS where Marks>75 order by right(Name,3),ID ASC;
Comment

sort by last two number sql

SELECT inft.port FROM interfaces AS intf ORDER BY SUBSTRING(intf.port, LOCATE('/', intf.port)+1, LENGTH(intf.port)) + 0
Comment

PREVIOUS NEXT
Code Example
Sql :: drop table 
Sql :: how to delete table sqlite 
Sql :: remove all records from table mysql 
Sql :: oracle current sequence value 
Sql :: row number mysql 
Sql :: drop all database tables oracle sql developer 
Sql :: column names in oracle sql 
Sql :: Oracle NLS_CHARACTERSET 
Sql :: how to find date from date table in sql 
Sql :: select tables with name like mysql 
Sql :: how to get slow query log in mysql 
Sql :: oracle new column 
Sql :: return insert results in POSTGRESQL 
Sql :: mariadb.service: Main process exited, code=exited, status=1/FAILURE 
Sql :: how to know password of mysql root in linux terminal 
Sql :: oracle asynchronous query 
Sql :: install mysql 8 linux 
Sql :: best sql course 
Sql :: hangfire clear all jobs 
Sql :: get only first row mysql 
Sql :: sql select data from last week 
Sql :: how to alter table column name in mysql 
Sql :: change default role snowflake 
Sql :: Insert from table tsql 
Sql :: oracle add auto_increment column to existing table 
Sql :: sql values not in another table 
Sql :: how to delete a record from sqlite in android 
Sql :: mysql change collation one column 
Sql :: delete dublicate rows sql 
Sql :: mysql CAST(amount as float) 
ADD CONTENT
Topic
Content
Source link
Name
1+4 =