Tag: database

  • MariaDB Example: How to Order by Date and Limit the Output to 10 Rows

    MariaDB Example: How to Order by Date and Limit the Output to 10 Rows

    Welcome to our blog post on MariaDB! In this tutorial, we will walk you through an example of how to effectively order your data by date and limit the output to only 10 rows using MariaDB. This feature is particularly useful when you have a large dataset and want to retrieve the most recent or…

  • How to Create a MariaDB Connect in PHP for WordPress

    How to Create a MariaDB Connect in PHP for WordPress

    In this blog post, we will explore the process of creating a MariaDB connect in PHP for your WordPress website. Connecting to a MariaDB database is essential for many WordPress applications, and PHP provides robust functionalities to establish a connection. Let’s dive in!

  • MSSQL datediff in seconds

    The following command on a Microsoft SQL Server calculates the difference in seconds between two datetimes: Example query: Result: If you need the result as a text and also want to add 3 digits after the seconds you can use the following example: Result:

  • Oracle top 1 record

    To select the top 1 records from an oracle database, you filter with the where statement on rownum = 1: If you want to select top 10 records from the table you use the following statement: