Rapid AI DAta Yields

Generative AI products for everyone

SFW

SQL

  • COUNT(*) vs COUNT(1) in SQL

    COUNT(*) vs COUNT(1) in SQL

    In SQL, counting rows is a fundamental operation, and there are a couple of common ways to do it: COUNT(*) and COUNT(1). At first glance, these statements might seem different, but they actually perform very similar functions. Is There Any Difference? Despite the different syntax, COUNT(*) and COUNT(1) generally produce the same results and performance […]

  • The Zen of SQL

    The Zen of SQL

    After a decade of working with Structured Query Language, I, Antonello Supino, have created The Zen of SQL. They goal is to summarize my nearly two decades of coding experience into compact guideline that is public and free to use by everyone who writes SQL code for work or passion. The Zen of SQL: 10 […]