Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
CREATE VIEW myView
AS
SELECT $IDENTITY
,Field1
FROM Table
--Assume the primary key is a composite of Col1 and Col2.
Select
RowNum=(Select Count(*) From TableName
Where Col1<=t1.Col1 And Col2 <=t1.Col2)
Col1, Col2, Col3, Col4
From TableName t1
Order By Col1, Col2