---
title: SQL Multiplication Witout a Cursor
description: Learn how to multiply rows in a table without a cursor using SQL in this quick tip. Explore a simple algorithm for efficient multiplication in your database.
---

[Blog](https://booking.datalabsolutions.ai/blog)

# [SQL Multiplication Witout a Cursor](https://booking.datalabsolutions.ai/blog/sql-multiplication-witout-a-cursor)

 Written by [Datalab](https://booking.datalabsolutions.ai/blog/author/datalab) | Apr 26, 2024 8:41:50 AM

#### Introduction

In this quick tip we will illustrate how you can multiply rows in a table together without using a cursor.

The SQL for this is not particularly difficult but the results are really useful.

#### Examples

The following sample illustrates creating a table, adding 3 values to that table using a table constructor, and then using the simple algorithm EXP(SUM(LOG(<>))) to multiply all three values together; 2 x 3 x 4 = 24.

[View full post](https://booking.datalabsolutions.ai/blog/sql-multiplication-witout-a-cursor)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Datalab"
  },
  "dateModified" : "2024-04-26T08:48:27.473Z",
  "datePublished" : "2024-04-26T08:41:50Z",
  "headline" : "SQL Multiplication Witout a Cursor",
  "image" : {
    "@type" : "ImageObject",
    "height" : 1282,
    "url" : "https://26014047.fs1.hubspotusercontent-eu1.net/hubfs/26014047/sql-multiplication.jpg",
    "width" : 1920
  },
  "mainEntityOfPage" : "https://booking.datalabsolutions.ai/blog/sql-multiplication-witout-a-cursor",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Blog"
  }
}
```