Search
 
SCRIPT & CODE EXAMPLE
 

SQL

consecutive numbers sql

SELECT DISTINCT l1.Num AS ConsecutiveNums FROMLogs AS l1, Logs AS l2, Logs AS l3WHERE l1.Num = l2.Num AND l2.Num = l3.Num ANDl1.Id = l2.Id - 1 AND l2.Id = l3.Id - 1;
Comment
PREVIOUS NEXT
Code Example
Sql :: delete * from where id = 1; 
Sql :: drop all triggers oracle 
Sql :: select into 
Sql :: json_value oracle 
Sql :: sql data types 
Sql :: mysql run script 
Sql :: sql order by two columns 
Sql :: insert query in sql 
Sql :: sqlalchemy bulk delete 
Sql :: add week ending date sql server 
Sql :: alter column to not null with default value sql server 
Sql :: postgre query date 
Sql :: sql unique constraint 
Sql :: mysql add hours to time field 
Sql :: mysql limit order by 
Sql :: insert select 
Sql :: EnvironmentError: mysql_config not found 
Sql :: oracle sql unique 
Sql :: how to find top 3 salary in sql 
Sql :: sql server check for value in multiple columns 
Sql :: mariadb case switch 
Sql :: soql update query 
Sql :: sql to c# model 
Sql :: distinct in sql 
Sql :: multiple row primary key 
Sql :: difference between in and between in sql 
Sql :: insert or update sql query 
Sql :: SQL Server Splitting a string column into multiple rows, while repeating ID column 
Sql :: oracle compile trigger 
Sql :: compare field sql server 
ADD CONTENT
Topic
Content
Source link
Name
8+2 =