Max and Selection of multiple columns in the same Query Oracle

Question

Could anybody tell me that how can I achieve this Query in oracle

select column1, columns2, max(rownumber) from table where .....;

Explanation: Select Query is so complicated and I need max to give UI Side "total count" of the record for paging and i will send the data only 20 or 30 records based on the paging size not full record.

Possible duplicate of Number of rows in Oracle SQL Select?

Asier Azkuenaga
– Asier Azkuenaga

2017-02-20 09:23:45 +00:00
Commented Feb 20, 2017 at 9:23 — Asier Azkuenaga
– Asier Azkuenaga, Commented Feb 20, 2017 at 9:23

user330315 · Accepted Answer · 2017-02-20 09:21:59Z

2

Use a window function:

select column1, columns2, count(*) over () as total_count from table where .....;

answered Feb 20, 2017 at 9:21

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Max and Selection of multiple columns in the same Query Oracle

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related