SQLiteQueryBuilder.BuildUnionQuery(String[], String, String) Method

Reference

Definition

Namespace:: Android.Database.Sqlite

Assembly:: Mono.Android.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Given a set of subqueries, all of which are SELECT statements, construct a query that returns the union of what those subqueries return.

[Android.Runtime.Register("buildUnionQuery", "([Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;", "GetBuildUnionQuery_arrayLjava_lang_String_Ljava_lang_String_Ljava_lang_String_Handler")]
public virtual string? BuildUnionQuery (string[]? subQueries, string? sortOrder, string? limit);

[<Android.Runtime.Register("buildUnionQuery", "([Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;", "GetBuildUnionQuery_arrayLjava_lang_String_Ljava_lang_String_Ljava_lang_String_Handler")>]
abstract member BuildUnionQuery : string[] * string * string -> string
override this.BuildUnionQuery : string[] * string * string -> string

Parameters

subQueries: String[]

an array of SQL SELECT statements, all of which must have the same columns as the same positions in their results

sortOrder: String

How to order the rows, formatted as an SQL ORDER BY clause (excluding the ORDER BY itself). Passing null will use the default sort order, which may be unordered.

limit: String

The limit clause, which applies to the entire union result set

Returns

String

the resulting SQL SELECT statement

Attributes: RegisterAttribute

Remarks

Given a set of subqueries, all of which are SELECT statements, construct a query that returns the union of what those subqueries return.

Java documentation for android.database.sqlite.SQLiteQueryBuilder.buildUnionQuery(java.lang.String[], java.lang.String, java.lang.String).

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

Applies to