Results for "Order by"
3 / 184 posts
Order by index number in SQL
SELECT empid, lastname FROM HR.Employees ORDER BY 1 DESC --order by first column SELECT empid, lastname FROM HR.Employees ORDER BY 2 DESC --order by second…
comma saparate Indexing mysql
Mar 19, 2026 1 min read
Filtering the data with TOP and OFFSET-FETCH In SQL
TOP: SELECT TOP (5) productid, unitprice FROM Production.Products WHERE categoryid = 1 ORDER BY unitprice DESC; SELECT TOP (5) WITH TIES productid, unitpri…
database mysql OFFSET-FETCH
Mar 19, 2026 3 min read
PySpark Built-in Functions
These functions are commonly used with groupBy() , agg() , or select() to compute things like sum, average, max, min, count, etc. PySpark functions come fr…
Aggregate apache spark for beginners big data tutorial
Mar 19, 2026 2 min read