Skip to main content

repeat function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns the string that repeats expr n times.

Syntax​

repeat(expr, n)

Arguments​

  • expr: A STRING expression.
  • n: An INTEGER expression.

Returns​

A STRING.

If n is less than 1, an empty string.

Examples​

SQL
> SELECT repeat('123', 2);
 123123
Last updated on