Theprogrammersfirst: Is there any function in aws redshift to find out the second largest record ?? or if no function what and how to find out the 2nd largest record?

2021-12-04

select * 
from peb_gateway_info pgi 
order by 'name' desc limit 1,1;

enter image description here

from Recent Questions - Stack Overflow https://ift.tt/3xRiNmE
https://ift.tt/3Ez71zK

Anonymous6/09/2023 05:50:00 pm
Establishing an Amazon Redshift Cloud Data Warehouse Consulting in DataStage is a crucial step to enable data integration and transformation processes with the power and scalability of Amazon’s cloud data warehousing solution. Here, we will guide you through the process of setting up the connection in DataStage, ensuring a seamless data flow between your DataStage environment and Amazon Redshift.
ReplyDelete
Replies