Title: SQL Tips and Tricks  
Author: Debra Howell Mar 22, 2022
Last Changed by: Joanne Elisa Leary Apr 16, 2024
Tiny Link: (useful for email) https://confluence.cornell.edu/x/GnWZGQ
Export As: Word · PDF  
Hierarchy
Parent Page
    Page: Getting Help
Children (22)
    Page: Capturing diacritics in exporting data
    Page: Getting Data that is Null when it is not stored as Null
    Page: Parsing out call numbers
    Page: Specifying Ranges
    Page: srs_marctab record version
    Page: Optimizing Queries
    Page: MARC Query Samples
    Page: Working with Subject Headings
    Page: Multiple Fiscal Years - DRAFT
    Page: Querying array elements from a table's data blob (useful for non-MetaDB data)
Labels
There are no labels assigned to this page.
Recent Changes
Time Editor  
Apr 16, 2024 17:31 Joanne Elisa Leary View Changes
Apr 16, 2024 16:58 Joanne Elisa Leary View Changes
Mar 04, 2024 16:41 Sharon Helen Markus View Changes
Feb 22, 2024 11:30 Joanne Elisa Leary View Changes
Feb 22, 2024 10:29 Joanne Elisa Leary  
Outgoing Links
External Links (24)
    https://confluence.cornell.edu/display/folioreporting/Aggre…
    https://confluence.cornell.edu/display/folioreporting/Using…
    https://confluence.cornell.edu/display/folioreporting/Optim…
    https://confluence.cornell.edu/display/folioreporting/Find+…
    https://confluence.cornell.edu/pages/viewpage.action?pageId…
    https://confluence.cornell.edu/display/folioreporting/Find+…
    https://confluence.cornell.edu/display/folioreporting/Conve…
    https://confluence.cornell.edu/display/folioreporting/MARC+…
    https://confluence.cornell.edu/display/folioreporting/Multi…
    https://confluence.cornell.edu/display/folioreporting/Best+…
    https://confluence.cornell.edu/display/folioreporting/Captu…
    https://confluence.cornell.edu/display/folioreporting/Impor…
    https://confluence.cornell.edu/display/folioreporting/Getti…
    https://confluence.cornell.edu/display/folioreporting/Worki…
    https://confluence.cornell.edu/display/folioreporting/Parsi…
    https://confluence.cornell.edu/display/folioreporting/Parsi…
    https://confluence.cornell.edu/display/folioreporting/Patte…
    https://confluence.cornell.edu/display/folioreporting/Conve…
    https://confluence.cornell.edu/display/folioreporting/Find+…
    https://confluence.cornell.edu/display/folioreporting/Speci…
    https://confluence.cornell.edu/pages/viewpage.action?pageId…
    https://confluence.cornell.edu/display/folioreporting/srs_m…
    https://confluence.cornell.edu/pages/viewpage.action?pageId…
    https://confluence.cornell.edu/display/folioreporting/Worki…
FOLIO Reporting (1)     Page: Using the VTEST Voyager Historical Data Snapshot