FREE AI-Enhanced Online MySQL Compiler - For learning & practice

Untitled*

You must execute the code again to save those values in the database.

-- INIT database
CREATE TABLE Product (
  ProductID INT AUTO_INCREMENT KEY,
  Name VARCHAR(100),
  Description VARCHAR(255),
  ProductGroup INT
);

INSERT INTO Product(Name, Description,ProductGroup) VALUES ('Entity Framework Extensions', 'Use <a href="https://entityframework-extensions.net/" target="_blank">Entity Framework Extensions</a> to extend your DbContext with high-performance bulk operations.',1);
INSERT INTO Product(Name, Description,ProductGroup) VALUES ('Dapper Plus', 'Use <a href="https://dapper-plus.net/" target="_blank">Dapper Plus</a> to extend your IDbConnection with high-performance bulk operations.',1);
INSERT INTO Product(Name, Description,ProductGroup) VALUES ('C# Eval Expression', 'Use <a href="https://eval-expression.net/" target="_blank">C# Eval Expression</a> to compile and execute C# code at runtime.',2);

-- QUERY database
SELECT 
productId, 
Name,
Description,
LAG(productId) OVER w previousPorudctId,
LEAD(productId) OVER w nextProductId
FROM Product
where ProductGroup = 1
WINDOW w AS (ORDER BY Name)
order by Name
;

productId	Name	Description	previousPorudctId	nextProductId
2	Dapper Plus	Use Dapper Plus to extend your IDbConnection with high-performance bulk operations.	NULL	1
1	Entity Framework Extensions	Use Entity Framework Extensions to extend your DbContext with high-performance bulk operations.	2	NULL