Concepedia

Common Table Expressions

Common Table Expression is a syntactic construct in Structured Query Language that enables the definition of a temporary named result set, derived from a query expression, which can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement to enhance readability and simplify complex query logic.

6

Publications

165

Citations

23

Authors

8

Institutions

Publications per year

2017–2026

3

Parents

Publications

6

Keyword search on relational data streams

Alexander Markowetz, Yin Yang, Dimitris Papadias · 2007 · 94 citations

, , +14

PASTA: Table-Operations Aware Fact Verification via Sentence-Table Cloze Pre-training

Zihui Gu, Ju Fan, Nan Tang et al. · 2022 · 20 citations · Full text

, , +15

One WITH RECURSIVE is Worth Many GOTOs

Denis Hirn, Torsten Grust · 2021 · 18 citations

, , +13

Efficient and Portable Einstein Summation in SQL

Mark Blacher, Julien Klaus, Christoph Staudt et al. · Proceedings of the ACM on Management of Data · 2023 · 13 citations

, , +17

Functional-Style SQL UDFs With a Capital 'F'

Christian Duta, Torsten Grust · 2020 · 11 citations

, , +14

1–5 of 6

Authors

23

  1. TG
    Torsten Grust

    University of Tübingen, Germany

    2 publications · 29 citations

    2

    h-index

  2. GC
    George C. Caragea

    University of Maryland, College Park, United States

    1 publications · 11 citations

    1

    h-index

  3. CD
    Christian Duta

    University of Tübingen, Germany

    1 publications · 11 citations

    1

    h-index

  4. PN
    Preslav Nakov

    Sofia University "St. Kliment Ohridski", Bulgaria

    1 publications · 20 citations

    1

    h-index

  5. NT
    Nan Tang

    Tsinghua University, China

    1 publications · 20 citations

    1

    h-index

1–5 of 23

Institutions

8

  1. University of Tübingen

    Tübingen, Germany

    2 h-index

    4 publications

    58 citations

  2. Qatar Airways (Qatar)

    Doha, Qatar

    1 h-index

    1 publications

    20 citations

  3. University of Kentucky

    Lexington, United States

    1 h-index

    5 publications

    55 citations

  4. Renmin University of China

    Beijing, China

    1 h-index

    4 publications

    80 citations

  5. Hong Kong University of Science and Technology

    Hong Kong, Hong Kong

    1 h-index

    3 publications

    282 citations

  6. Mohamed bin Zayed University of Artificial Intelligence

    Abu Dhabi, United Arab Emirates

    1 h-index

    1 publications

    20 citations

  7. Florida State University

    Tallahassee, United States

    1 h-index

    1 publications

    11 citations

  8. Pivotal Labs

    San Francisco, United States

    1 h-index

    4 publications

    44 citations

1–8 of 8

Venues

  1. 1

    h-index

  2. Proceedings of the VLDB Endowment

    PVLDB · 1 publications · 11 citations

    1

    h-index

  3. Proceedings of the ACM on Management of Data

    1 publications · 13 citations

1–3