Skip To Main Content
Select Case on Muck Rack

Select Case

As seen in: Amazon Web Services, DEV Community, Towards Data Science, KDnuggets, CSDN, SQL Server Central, itpub.net
Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work. Claim your profile

Get in touch with Select

Contact Select, search articles and posts on X, monitor coverage, and track replies from one place.

Learn more about Muck Rack

Actions

Share this page

Is this you?

As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile

Articles

해커랭크 - Basic (SQL)

|
By Select Case
| velog.io
Weather Observation 8 Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates.
Open in Who Shared Issue with article?

ROLLUP

|
By Select Case, César Castro
| DEV Community
Understanding the Use of the ROLLUP Function in SQL The ROLLUP function is a powerful tool in SQL that allows you to generate subtotals and grand totals in aggregated queries. This feature is particularly useful for reports and analysis, where there is a need to calculate consolidated values at different levels of detail. What is ROLLUP? The ROLLUP function is used in conjunction with the GROUP BY clause to create hierarchical groupings.
Open in Who Shared Issue with article?

Accelerate Amazon Redshift Data Lake queries with AWS Glue Data Catalog Column Statistics | Amazon Web Services

|
By Select Case
| Amazon Web Services
Amazon Redshift enables you to efficiently query and retrieve structured and semi-structured data from open format files in Amazon S3 data lake without having to load the data into Amazon Redshift tables. Amazon Redshift extends SQL capabilities to your data lake, enabling you to run analytical queries. Amazon Redshift supports a wide variety of tabular data formats like CSV, JSON, Parquet, ORC and open tabular formats like Apache Hudi, Linux foundation Delta Lake and Apache Iceberg.
Open in Who Shared Issue with article?
See all 12 articles