circle-info
Webinar | The Great Database Exodus: Navigating Strategic Risk in the Post-Oracle MySQL Era
Watch Nowarrow-up-right
LogoLogo
search
⌘Ctrlk
Download MariaDBContact Us
  • Home
  • MariaDB Platform
  • Server
  • MaxScale
  • Analytics
  • Galera Cluster
  • Connectors
  • Tools
  • MariaDB Cloud
  • Release Notes
  • General Resources
GitBook Assistant
GitBook Assistant
Working...Thinking...
GitBook Assistant
Good morning

I'm here to help you with the docs.

⌘Ctrli
AI Based on your contextquestion-circle
LogoLogo
  • serverMariaDB Server Documentation
  • rabbit-runningQuickstart Guides
  • tvServer Usage
  • gearServer Management
  • shield-halvedSecurity
  • house-blankArchitecture
  • wrenchClients & Utilities
  • chart-mixedHA & Performance
  • paperclipReference
    • SQL Structure
    • SQL Statements
      • Comment Syntax
      • Account Management
      • Administrative Statements
      • Data Definition (DDL)
      • Data Manipulation (DML)
        • Changing & Deleting Data
        • Inserting & Loading Data
        • Selecting Data
          • DUAL
          • FOR UPDATE
          • GROUP BY
          • LIMIT
          • LOCK IN SHARE MODE
          • Optimizer Hints
          • ORDER BY
          • PROCEDURE
          • SELECT
          • SELECT INTO DUMPFILE
          • SELECT INTO OUTFILE
          • SELECT ... OFFSET ... FETCH
          • SELECT WITH ROLLUP
          • Common Table Expressions (CTE)
          • Joins
          • Set Operations
          • Subqueries
      • Geometry Statements
      • Prepared Statements
      • Programmatic & Compound Statements
      • Stored Routine Statements
      • Table Statements
      • Transactions
    • SQL Functions
    • Data Types
    • Plugins
    • System Tables
    • Error Codes
    • Client/Server Protocol
    • Product Development
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. paperclipReferencechevron-right
  2. SQL Statementschevron-right
  3. Data Manipulation (DML)

Selecting Data

Learn to select data in MariaDB Server using SQL. This section covers various SELECT statement clauses, including WHERE, GROUP BY, and ORDER BY, to retrieve and filter your data effectively.

DUALchevron-rightFOR UPDATEchevron-rightGROUP BYchevron-rightLIMITchevron-rightLOCK IN SHARE MODEchevron-rightOptimizer Hintschevron-rightORDER BYchevron-rightPROCEDUREchevron-rightSELECTchevron-rightSELECT INTO DUMPFILEchevron-rightSELECT INTO OUTFILEchevron-rightSELECT ... OFFSET ... FETCHchevron-rightSELECT WITH ROLLUPchevron-rightCommon Table Expressions (CTE)chevron-rightJoinschevron-rightSet Operationschevron-rightSubquerieschevron-right
PreviousLOAD XMLchevron-leftNextDUALchevron-right

Last updated 7 months ago

Was this helpful?

LogoLogo

Products

  • Enterprise Platform
  • Community Server
  • Download MariaDB
  • Pricing

Support

  • Customer Login
  • Technical Support
  • Remote DBA
  • Professional Services

Resources

  • MariaDB Blog
  • Webinars
  • Customer Stories
  • MariaDB Events
  • Documentation
  • Developer Hub

Company

  • About MariaDB
  • Newsroom
  • Leadership
  • MariaDB Careers
  • Legal
  • Privacy Policy

© 2026 MariaDB. All rights reserved.

Was this helpful?