Re: Select first with rownumber ?

What !? I was counting on this and other features to convince to upgrade to IDS 10... :( well other's features are enough to upgrade ) But Hendrik, Why do you need your query to have rownumbers? Maybe the new SKIP, LIMIT (Syn. for FIRST) expressions in the SELECT clause that filters the rows returned by the engine could help you. J. PS: If SKIP, LIMIT, FIRST are implemented in the SELECT clause then ROWNUMBER implemenation should be easy... Maybe in UC4 this feature could be implemente... Art S. Kagel escribis: > Hendrik Schinnenburg wrote: > >>Hello NG, >>i try to write a query, which get a select with the rownumber. such as >> >>" select first 10 *, rownumber from table order by value " >> >>I want to have the following result : >> >>a, 1 >>b, 2 >>c, 3 >>d, 4 >>e, 5 >> >> >>Everytime i want the number 1 to count of first. >> >>This must be in an sql select statement without any procedure. >> >>How can i do that ? > > > Sorry, but IDS has no concept of ROWNUMBER and the ANSI SQL std does not > require it. That admittedly useful feature is an extension supported by > many RDBMSes, but not IDS. There was a rumor i short time ago, propagated > by me unfortunately (passing on bad info), that IDS 10.00.UC.3 would have > that feature, but it unfortunately does not. > > Art S. Kagel sending to informix-list