'Where can I find what SQL dialect that MarkLogic TDE based SQL support?

MarkLogic TDE enables SQL 'like' access to the document data. Hence via common ODBC driver, other BI tools could possibly access ML DB in a 'relation db' way. However the challenge I have is to know which SQL dialet ML supports.

For example, I want to find how to find the first 10 records to get a snippet of the data. I could do that with

select top 10 * from book (ms sql)

or

select * from book where rownum <= 10 (oracle sql)

How to do the same with MarkLogic SQL?

There are actually many such types of sql syntax questions. I need to find the equivalent of what I normally used with ms sql.
Is there a wiki page to show the difference between ML SQL and MS SQL?

sqlmarklogictdemarklogic-10


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions