Search code examples
sqlmarklogictdemarklogic-10

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?

Solution

  • In general, MarkLogic supports the syntax from the SQL92 standard.

    Supported SQL Statements, Functions and Types

    This section describes the SQL statements and functions supported in MarkLogic. The topics are: