circle-info
Webinar | The Great Database Exodus: Navigating Strategic Risk in the Post-Oracle MySQL Era
Register 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 afternoon

I'm here to help you with the docs.

Ctrli
AI Based on your contextquestion-circle
  • serverMariaDB Server Documentation
  • rabbit-runningQuickstart Guideschevron-right
  • tvServer Usagechevron-right
  • gearServer Managementchevron-right
  • shield-halvedSecuritychevron-right
  • house-blankArchitecturechevron-right
  • wrenchClients & Utilitieschevron-right
  • chart-mixedHA & Performancechevron-right
  • paperclipReferencechevron-right
    • SQL Structurechevron-right
    • SQL Statementschevron-right
      • Comment Syntax
      • Account Managementchevron-right
      • Administrative Statementschevron-right
      • Data Definition (DDL)chevron-right
      • Data Manipulation (DML)chevron-right
        • Changing & Deleting Datachevron-right
        • Inserting & Loading Datachevron-right
        • Selecting Datachevron-right
          • DUAL
          • FOR UPDATE
          • GROUP BY
          • LIMIT
          • LOCK IN SHARE MODE
          • Optimizer Hintsarrow-up-right-from-square
          • ORDER BY
          • PROCEDURE
          • SELECT
          • SELECT INTO DUMPFILE
          • SELECT INTO OUTFILE
          • SELECT ... OFFSET ... FETCH
          • SELECT WITH ROLLUP
          • Common Table Expressions (CTE)chevron-right
          • Joinschevron-right
          • Set Operationschevron-right
          • Subquerieschevron-right
      • Geometry Statementschevron-right
      • Prepared Statementschevron-right
      • Programmatic & Compound Statementschevron-right
      • Stored Routine Statementschevron-right
      • Table Statementschevron-right
      • Transactionschevron-right
    • SQL Functionschevron-right
    • Data Typeschevron-right
    • Pluginschevron-right
    • System Tableschevron-right
    • Error Codeschevron-right
    • Client/Server Protocolchevron-right
    • Product Developmentchevron-right
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?