PDA

View Full Version : Bugs in SQL using Select Top * from example order by account_no Top is ignored.



douglasg76
2012-04-26, 00:43
I am interested in buying Lianja, I'm beta testing.
But I would like not to ignore the comments.
I have been testing Lianja Console vfp recital:

please fix it, SQL error, when you used order by the Top is ignored.

IN SQL Server

first reccord
select top (1) * from example order by asc account_no

last reccord
select top (1) * from example order by desc account_no

Be first Record
select top (10) * from example order by account_no

But this fails. or should integrate something like Mysql server
with Limit.

IN Mysql Server
select * from department order by asc iddepartamento Limit 1
last
select * from department order by iddepartamento desc Limit 1
Be first Record
select * from department order by iddepartamento Limit 10