---
title: "Discussion on \"Oracle Database 26ai: consultas mais simples com QUALIFY\" | Hashnode"
description: "Discussion on \"Oracle Database 26ai: consultas mais simples com QUALIFY\". Se você já precisou escrever consultas como:\n\nacima da média\n\nmaiores salários\n\nprimeiro/último registro\n\nmaior valor por grupo\n\n\nprovavelmente criou subqueries assim:\nSELECT *\nFROM (\n  SELECT t.*, ...\n  FROM tabela t\n)\nWHERE ...\n\nDurante anos, esse ..."
url: "https://hashnode.com/posts/oracle-database-26ai-consultas-mais-simples-com-qualify/697bd480b8969736e36653cc"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Oracle Database 26ai: consultas mais simples com QUALIFY](https://batalha.hashnode.dev/oracle-database-26ai-consultas-mais-simples-com-qualify?utm_source=hashnode&utm_medium=feed)

Se você já precisou escrever consultas como: acima da média maiores salários primeiro/último registro maior valor por grupo provavelmente criou subqueries assim: SELECT \* FROM ( SELECT t.\*, ... FROM tabela t ) WHERE ... Durante anos, esse ...

Jan 29 · 2 min read · batalha.hashnode.dev  
Read the article

-   [#orclapex](https://hashnode.com/tag/orclapex)

## Written by

[Marcelo Batalha](https://hashnode.com/@batalha)

@batalha · São Paulo, Brasil

  
[View profile](https://hashnode.com/@batalha)

Oracle ACE, Mestre em Eng. de Computação, Professor e Engenheiro de Computação

Oracle ACE and Oracle APEX Cloud Developer Certified Professional with over 20 years of experience in Oracle tools and IT governance. Holds a Master's degree in Computer Engineering and has received additional training from the University of California, Irvine, establishing a strong foundation in both theoretical knowledge and practical applications. Also serves as a Postgraduate Professor specialized in Full-Stack Development at University Senac in Brazil. Currently responsible for IT Governance at Brazilian software company Grupo Giap. Active contributor to the Oracle community, and speaker at international conferences such as Kscope24, KScope25, Oracle APEX Tour Latinoamérica and Latin America Oracle Users Groups (LAOUC) Community Tour.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
