SQL Server provides TOP clause to return top n row from query,
for ex : SELECT TOP 5 * FROM Tbl_Name order by col_name
in PostgreSql we have LIMIT clause limit the number of rows returned,
for ex : SELECT * FROM Tbl_Name ORDER BY col_name LIMIT 5
PostgreSql and MySql also provides cool feature with LIMIT clause called OFFSET
for ex : SELECT * FROM Tbl_Name ORDER BY col_name LIMIT 5 OFFSET 20
it will skip the row from 1 to 19 and return the record from 20th to 25th record.
All about data processing & analytics. Open source database,No-SQL and Hadoop. Discussed issues/solution which I've got during my experience..
Wednesday, July 7, 2010
TOP n query in PostgreSQL
Labels:
PostgreSQL
Subscribe to:
Post Comments (Atom)
Labels
- #agriculture (1)
- #ai (5)
- #pdf (1)
- Big Data (30)
- blogging (3)
- data analytics (5)
- data science (7)
- Deep Learning (4)
- Hadoop (28)
- Hadoop Eco System (27)
- hdfsCommands (4)
- Hive (5)
- IssueSolution (4)
- jobs (3)
- links (1)
- Machine Learning (4)
- mahout (2)
- MapReduce (1)
- MongoDB (6)
- MySQL (4)
- PlpgSQL (8)
- postgres (6)
- PostgreSQL (53)
- R (20)
- RHadoop (2)
- search keywords (1)
- social (2)
- spark (3)
- twitter (6)
- usecase (2)
- visualization (7)
- weka (1)
No comments:
Post a Comment