Update of /cvsroot/monetdb/sql/src/test
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv27554/src/test
Added Files:
rank.sql
Log Message:
propagated changes of Friday Mar 30 2007 - Monday Apr 02 2007
from the SQL_2-16 branch to the development trunk
--- NEW FILE: rank.sql ---
select ROW_NUMBER() over () as foo from tables;
select ROW_NUMBER() over (PARTITION BY schema_id) as foo, schema_id from tables;
select ROW_NUMBER() over (PARTITION BY schema_id ORDER BY schema_id) as foo,
schema_id from tables;
select ROW_NUMBER() over (ORDER BY schema_id) as foo, schema_id from tables;
select RANK() over () as foo from tables;
select RANK() over (PARTITION BY schema_id) as foo, schema_id from tables;
select RANK() over (PARTITION BY schema_id ORDER BY schema_id) as foo,
schema_id from tables;
select RANK() over (ORDER BY schema_id) as foo, schema_id from tables;
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
