Search found 732 matches
- Sat Apr 21, 2012 11:23 pm
- Forum: Vertica Analytics
- Topic: RANK and DENSE_RANK
- Replies: 1
- Views: 20638
Re: RANK and DENSE_RANK
If two rows receive the same rank DENSE_RANK leaves no gaps in the ranking sequence, while RANK do. The best way to show it - example, I will skip PARTITION BY for simplicity. Table: CREATE TABLE Scores ( "name" varchar(80), scores int ); Data: select * from scores order by scores desc; name | score...
- Sat Apr 21, 2012 10:29 pm
- Forum: New to Vertica
- Topic: Add column to table
- Replies: 8
- Views: 24212
Re: Add column to table
As I know Vertica team already works on it and... who knows may be it will be available in a next update or version.fsalvelt wrote:Why do you think that a DROP and ADD option isn't available out of the box?
- Sat Apr 21, 2012 10:01 pm
- Forum: New to Vertica Database Administration
- Topic: Change Database Owner
- Replies: 4
- Views: 11859
Re: Change Database Owner
Hi!
[DELETED]
[DELETED]
- Sat Apr 21, 2012 8:46 pm
- Forum: Vertica Backup & Recovery
- Topic: Backup and Restore for tables
- Replies: 7
- Views: 20842
Re: Backup and Restore for tables
Hi!
[DELETED]
[DELETED]