Paging in Teradata for Web application

Database
Enthusiast

Paging in Teradata for Web application

Hi,

I try to create fast paging in web application?
Is any SQL syntax in Teradata which is similair
to LIMIT and OFFSET in MySQL?
(Example: http://www.cgi-interactive-uk.com/mysql_paging_results.html)

Thanks,
Vesoni
2 REPLIES
Enthusiast

Re: Paging in Teradata for Web application

Paging requires the answer set to be cached somewhere on a server. Teradata does not have this kind of facility, so you have to build your own or use one from an existing Application Servers.
Enthusiast

Re: Paging in Teradata for Web application

Hi Daniel,

Thank you for info.

Regards