1

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?

IMSoP
  • 89,526
  • 13
  • 117
  • 169
XCELERENT - I want to dance
  • 523
  • 2
  • 7

1 Answers1

2

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:

Mads Hansen
  • 63,927
  • 12
  • 112
  • 147