^<имя_класса>I(<имя_индекса>,<ключевое_выражение>,ID)=""

Index indexName On (a, b);

^globalI("indexName","A","B",1)=""

s name=$na(^globalI("indexName","A","B",1))

w $na(^(""))

TEST>w $d(^O("Df"))
10
TEST>w $na(^(""))
^O("")
TEST>w $zr
^O("Df")

DEV>w ##class(LBCDBLab).SpecimenExists(1)

Set person = ##class(Sample.Person).SSNKeyOpen("111-22-3333",2,.sc)
//
Set success = ##class(Sample.Person).SSNKeyExists("111-22-3333",.id)

sqlQuit() /* SQL-функция для причин увольнения (последнее местоработы) */
	n sql,flt
	s sql="Select *, "
	s sql=sql_"a.name as article, "
	s sql=sql_"r.name as reason "
	s sql=sql_"From "
	s sql=sql_"soi_arh_data.quit as q "
	s sql=sql_"left join soi_arh_data.article as a On a.code=q.quitArticle "
	s sql=sql_"left join soi_arh_data.reason as r On r.code=q.quitReason "
	s sql=sql_"Where registration=? "
 	s flt=$$filter^|mvrNS|mvr.sys.fnc(Table,View)
 	s:flt'="" sql=sql_"And "_flt_" "
	s sql=sql_"Order by "
	s sql=sql_"dat"
	q sql

SELECT *, %vid FROM (SELECT ....) v WHERE %vid BETWEEN 5 AND 10

v WHERE

	s sql="Select * "
	s sql=sql_"from mvr_data.listCol "
	s sql=sql_"where listTbl->name = ? "
	s sql=sql_"AND (notView =0 Or notView is Null) "
	s sql=sql_"AND listTbl->tableCls->name = ? "
	s sql=sql_"AND listTbl->tableCls->task->name = ? "
	s sql=sql_"ORDER BY sort"	
	s o=##class(%ResultSet.SQL).%Prepare(sql,.err,"",View,Table,task)
	&html<<tr>>
		&html<<td class='mvr_list_linetyp'>>
			&html<>
		&html<</td>>
	while o.%Next() {
		d FINDCOL
	}
	&html<</tr>>
	k o

SELECT * FROM mvr_data.tableCls WHERE task->name=? ORDER BY description

Select %vid,* From (SELECT * FROM mvr_data.tableCls WHERE task->name=? ) Where %vid between ? and ? ORDER BY description

Select * From (SELECT * FROM mvr_data.tableCls WHERE task->name=? ) Where %vid between ? and ? ORDER BY description