Lmst
Login

#SQLQueries

N-gated Hacker Newsngate
2025-12-20

🎉🚀 Introducing TailwindSQL: because your SQL queries were just begging for a utility-first approach! 😂 Now you can over-engineer your database calls in React Server Components with style! ✨
github.com/mmarinovic/tailwind

Hacker Newsh4ckernews
2025-12-20

TailwindSQL – Like TailwindCSS, but for SQL Queries in React Server Components

github.com/mmarinovic/tailwind

Python Job Supportpythonjobsupport
2025-12-15

SQL Interview Question – How to find nth highest salary?

This video is a part of the series on scenario based SQL Query Interview Questions. This videos discusses the most commonly ... source

quadexcel.com/wp/sql-interview

Andrew Armstrongtechygeekshome@techhub.social
2025-09-15

Reporting on Office 365 Channels with SQL Query | #Evergreen #Guide #Microsoft #SystemCenter #Office365Analytics #SQLQueries #DataReporting #CloudComputing #MicrosoftOfficeTools 
tinyurl.com/27kbjdb6

Anthony Powellajguides
2025-09-15

Reporting on Office 365 Channels with SQL Query |     
tinyurl.com/292j43qo

N-gated Hacker Newsngate
2025-05-10

📧➡️📂 Oh, look! Now you can turn your endless sea of unread promotional emails into a neat . Because who wouldn't want to spend their weekend wrestling with SQL queries to find that Groupon from 2012 instead of just using the search bar? 🙄
github.com/marcboeker/gmail-to

zartom
2025-04-19

Finding a Specific Value Across Multiple SQL Tables: A Comprehensive Guide
Find value in multiple tables SQL using DB2. Data type mismatches are a common query troubleshooting issue. Learn how to avoid errors by carefully considering data types.
tech-champion.com/programming/
...

zartom
2025-04-19

How to Overcome the Listagg Limit of 4000 Characters
Overcome the LISTAGG limit in SQL for large datasets! Strategies like chunking and recursive CTEs help manage massive concatenated strings. Learn practical solutions for efficient SQL queries.
tech-champion.com/database/how
...

zartom
2025-04-19

How to Determine the Total Record Count of All Persistent Tables in a Database?
Learn how to accurately count persistent table records in your database, avoiding estimated counts. We'll explore various methods, from simple queries to stored procedures, to get precise counts, even in dynamic environments. Perfect for robust database management.
tech-champion.com/programming/...

zartom
2025-04-19

Troubleshooting SQL IN Operator Error with Multiple Columns
Troubleshooting SQL IN operator errors with multiple columns. Learn how to avoid errors like "[Code: -811, SQL State: 21000]" by using AND/OR instead of IN for multiple columns. Get solutions and best practices for SQL queries.
tech-champion.com/programming/
...

zartom
2025-04-19

Find the Oldest Even-Numbered Patient Visit Using SQL
Learn to extract the Oldest Even Visit SQL record! This tutorial covers various SQL techniques, including CTEs and subqueries, to efficiently retrieve this data. Optimize your queries for speed and handle missing data.
tech-champion.com/database/sql
...

zartom
2025-04-19

Calculating Portfolio Average Cost with SQL: A Comprehensive Guide
Learn to calculate your Portfolio Average Cost using SQL queries! This guide shows you how to track investment performance, even with complex transactions. Get a robust analysis for informed decisions. PortfolioAnalysis
tech-champion.com/database/sql
...

zartom
2025-04-19

SQL Server User Summary: Efficiently Summarizing User Data
Master SQL Server User Summary: Learn efficient data aggregation, conditional reporting, & query optimization techniques for insightful data analysis.
tech-champion.com/database/sql
...

zartom
2025-04-19

Retrieve Account Balance: SQL Methods for Finding Latest Account Values
Retrieve Account Balance efficiently from your SQL database! Learn multiple methods: subqueries, window functions, and CTEs. Optimize for readability & performance.
tech-champion.com/database/sql
...

zartom
2025-04-19

Optimizing SQL Queries: Efficiently Finding the Previous Sale Date
Optimize SQL queries for Previous Sale Date using window functions like LAG(). Improve database performance & write efficient SQL queries.
tech-champion.com/database/sql
...

Python Job Supportpythonjobsupport
2025-04-03

learn sql, sql cheatsheet

source

quadexcel.com/wp/learn-sql-sql

ResearchBuzz: Firehoseresearchbuzz_firehose@rbfirehose.com
2025-03-31

And Now It’s All This: SQL help from ChatGPT. “I had a couple of SQL database queries that I wanted to improve. Instead of going my usual route of searching for the answer in SQLite’s documentation, I decided to give ChatGPT a crack at it. I hoped that I would not only get better queries, but that I’d also learn something about SQL by studying the answers. It took a couple of tries, but I […]

https://rbfirehose.com/2025/03/31/and-now-its-all-this-sql-help-from-chatgpt/

N-gated Hacker Newsngate
2025-03-29

🎉 🎩 Behold, the Postgres Language Server! Because who doesn't want their database management peppered with programmer mysticisms and AI-generated gibberish? 🤖🔍 Fear not, fellow developers, your SQL queries can now be mired in even more layers of abstraction and confusion! 🙃
github.com/supabase-community/

zartom
2025-03-29

Finding a Specific Value Across Multiple SQL Tables: A Comprehensive Guide
Find value in multiple tables SQL using DB2. Data type mismatches are a common query troubleshooting issue. Learn how to avoid errors by carefully considering data types.
tech-champion.com/programming/
...

zartom
2025-03-29

How to Overcome the Listagg Limit of 4000 Characters
Overcome the LISTAGG limit in SQL for large datasets! Strategies like chunking and recursive CTEs help manage massive concatenated strings. Learn practical solutions for efficient SQL queries.
tech-champion.com/database/how
...

Client Info

Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst