Results 1 to 3 of 3

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

  1. #1
    Junior Member
    Join Date
    Feb 2012
    Posts
    11

    Exclamation Bugs in SQL using Select Top * from example order by account_no Top is ignored.

    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

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,712
    Converted to Ticket: LIMIT working correctly, TOP <expN> and TOP (<expN>) ignored if an ORDER BY clause included. The TOP problem has been fixed and will be available in the Beta 8 Refresh 1.

  3. #3
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,261
    This has been fixed in beta8 refresh 1

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us