SQL Access
2 отговора
215 прегледа
SQL Access
Kak da napisha SQL query za Access tai che da izbira 10 reda zapochvaiki ot 5ia
V MyQSL bih napisal
select * from aaa limit 5,10;
kak da napisha sashtoto za Access
V MyQSL bih napisal
select * from aaa limit 5,10;
kak da napisha sashtoto za Access
Re: SQL Access
Reshih problema taka:
SELECT TOP " & HowMuch & " * FROM COUNTRY WHERE COUNTRY_ID NOT IN" &_
"(SELECT TOP " & Start & " COUNTRY_ID FROM COUNTRY ORDER BY COUNTRY_ID) ORDER BY COUNTRY_ID;"
SELECT TOP " & HowMuch & " * FROM COUNTRY WHERE COUNTRY_ID NOT IN" &_
"(SELECT TOP " & Start & " COUNTRY_ID FROM COUNTRY ORDER BY COUNTRY_ID) ORDER BY COUNTRY_ID;"