Update of /cvsroot/monetdb/sql/src/test
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv13637/src/test
Modified Files:
Tag: SQL_2-16
rank.sql
Log Message:
We implemented RANK as ROW_NUMBER which isn't correct afcourse
So now added ROW_NUMBER and a new implementation for RANK.
Index: rank.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Attic/rank.sql,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- rank.sql 31 Mar 2007 17:21:35 -0000 1.1.2.1
+++ rank.sql 31 Mar 2007 20:34:03 -0000 1.1.2.2
@@ -1,3 +1,8 @@
+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;
-------------------------------------------------------------------------
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
