sql search

jda jda at his.com
Thu Apr 20 08:26:42 CDT 2006


>
>But Ivan use not ID but count(*)
>
>If you update ID ... (Hey! You make ORDERED LISTs, right? :)
>Then may be more correct to use something as
>
>   select *
>   from tableA
>   where id > (select max(id) - 15 from tableA )
>

Yes, thanks, that works nicely, too, and is more direct.

Jon


More information about the Valentina-beta mailing list