StackOverflow Questions for Tag: sql-function

MariaT

Reputation: 53

SQL Function with multiple CASE WHEN in the WHERE clause - slow performance

sql-servert-sqlquery-optimizationsql-function

Score: 0

Answers: 4

Haoest

Reputation: 13896

Table-Valued Function(TVF) vs. View

sql-serversql-viewsql-function

Score: 96

Answers: 4

Austin

Reputation: 41

Using SQL , how do I select the max values when there is more than one with the same max value?

sqlsubquerymaxaggregatesql-function

Score: -2

Answers: 2

Anand

Reputation: 1387

How to create a temporary function in PostgreSQL?

sqlpostgresqlsql-function

Score: 122

Answers: 4

xi20

Reputation: 139

Passing array to WHERE IN on multiple columns in a function

sqlarrayspostgresqlplpgsqlsql-function

Score: 1

Answers: 1

ClearlyClueless

Reputation: 762

Calculate rolling adjusted date based on date from parent row - lag / recursion

sqlsql-serverrecursive-querysql-function

Score: 0

Answers: 0

Duc Do

Reputation: 1

PL/SQL function to detect a one way character change between 2 strings

stringoracle-databaseplsqlstring-comparisonsql-function

Score: -2

Answers: 2

Prajwal Abraham

Reputation: 3

PostgreSQL function has syntax error at IF. Why?

sqlpostgresqlplpgsqlrdbmssql-function

Score: -3

Answers: 1

Ascerd

Reputation: 1

How to make this subquery return more than one row?

sqlpostgresqlsubquerysql-function

Score: -4

Answers: 2

Ben Klino

Reputation: 1

supabase function unable to access one table

postgresqlplpgsqlsupabasesql-functionsupabase-database

Score: 0

Answers: 1

Lukas Pistelak

Reputation: 1

JSON_KEYS function

sqlsql-functionsinglestore

Score: 0

Answers: 1

Adel

Reputation: 17

When i call this function for 700k record it is very slow

sqlsql-serverperformancequery-optimizationsql-function

Score: -4

Answers: 2

Serj.by

Reputation: 604

Using function result in WHERE clause in PostgreSQL

postgresqlselectwhere-clausesql-function

Score: 9

Answers: 3

Greg Witczak

Reputation: 1684

Reading Oracle boolean filed dbms_utility.is_cluster_database in statement

oracle-databaseplsqloracle11gsql-function

Score: 1

Answers: 3

Mridul Thakur

Reputation: 1

Why were functions introduced when stored procedures were already available in SQL Server?

sqlsql-serverstored-proceduressql-function

Score: 0

Answers: 1

Tarik

Reputation: 81711

Function vs. Stored Procedure in SQL Server

sqlsql-servert-sqlstored-proceduressql-function

Score: 1013

Answers: 19

user779159

Reputation: 9602

Set schema for objects referred to in postgres functions to same as the function itself

sqlpostgresqlsql-function

Score: 5

Answers: 2

joaomrossetto

Reputation: 21

Create function that returns a "SELECT" statement result

mysqlmysql-workbenchsql-function

Score: 2

Answers: 1

Lukasz Szozda

Reputation: 175546

Memoizable functions - Snowflake

snowflake-cloud-data-platformsql-function

Score: 1

Answers: 1

Charmi

Reputation: 83

Create SQL function using Django migrations command

sqldjangodjango-modelsdjango-migrationssql-function

Score: 0

Answers: 0

PreviousPage 1Next

StackOverflow Questions for Tag: sql-function

SQL Function with multiple CASE WHEN in the WHERE clause - slow performance

Table-Valued Function(TVF) vs. View

Using SQL , how do I select the max values when there is more than one with the same max value?

How to create a temporary function in PostgreSQL?

Passing array to WHERE IN on multiple columns in a function

Calculate rolling adjusted date based on date from parent row - lag / recursion

PL/SQL function to detect a one way character change between 2 strings

PostgreSQL function has syntax error at IF. Why?

How to make this subquery return more than one row?

supabase function unable to access one table

JSON_KEYS function

When i call this function for 700k record it is very slow

Using function result in WHERE clause in PostgreSQL

Reading Oracle boolean filed dbms_utility.is_cluster_database in statement

Why were functions introduced when stored procedures were already available in SQL Server?

Function vs. Stored Procedure in SQL Server

Set schema for objects referred to in postgres functions to same as the function itself

Create function that returns a &quot;SELECT&quot; statement result

Memoizable functions - Snowflake

Create SQL function using Django migrations command

Create function that returns a "SELECT" statement result