SQL Access

2 отговора 215 прегледа
#1

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

Отговор
в отговор на vladi #2

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;"

Отговор
в отговор на vladi #3

Re: SQL Access

Ti si absoluten genii

Отговор