TWO ROWS

Brand	Owner (click to sort)	Address	Description
TWOROWS	B'S SERVICES	1810 SAN CARLOS AVE. ATTN: BAIN BROOKS ALLEN TX 75002	TWO ROWS;restaurant and bar services;
TWOROWS	CST VENTURES	PO BOX 941428 PLANO TX 75094	TWO ROWS;restaurant and bar services;
TWOROWS	TBCT, Inc.	115 West Main Street Norman OK 73069	TWO ROWS;restaurant and bar services;
	Where the owner name is not linked, that owner no longer owns the brand

Technical Examples

Application of a scalar function across a varying number of records within an RDBMS using the RDBMS's SQL capabilities. This is accomplished by determining a last row in a group of rows, sorting the rows and passing the sorted rows to a scalar function, where the scalar function accepts each row and stores the accepted rows in a temporary file space. When the last row is encountered, the aggregate value is calculated using all of the rows in the group, and then a filter is applied on the rows so that only a row with the aggregate value is returned.