In Vertica we have the LIMIT command and I can get the TOP 3 values using a LIMIT 3 in combination with ordering the data descending...
Code: Select all
dbadmin=> select * from top;
numbers
---------
5
5
1
2
3
4
(6 rows)
dbadmin=> select * from top order by numbers desc limit 3;
numbers
---------
5
5
4
(3 rows)
How can I do this in Vertica?