Simple Vertica

Thursday, June 23, 2016

Limiting the number of rows in table

How to limit the number of records from a Vertica Query?

Select * from public.subscription limit 100;



Posted by Satyajit at 2:25 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Limit Rows in Vertica, Limiting Number of records in vertica

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

My photo
Satyajit
Santa Clara, California, United States
View my complete profile

Blog Archive

  • ►  2017 (1)
    • ►  December (1)
  • ▼  2016 (26)
    • ►  September (1)
    • ►  August (1)
    • ►  July (1)
    • ▼  June (23)
      • Important queries
      • Auto commit flag is on or off
      • Export table script
      • variable in vertica
      • Create and drop foreign key
      • Live Aggregate Projection
      • Anchor Projection
      • Pre-Join Projection
      • Types of Vertica Projections
      • Super projection
      • Create Vertica Projection ( Segmented and Unsegmen...
      • Create Primary key in vertica table
      • KSafety in Vertica
      • Find the default Isolation level in Vertica
      • Limiting the number of rows in table
      • List all databases and Show Database
      • Basic operations on a table in Vertica
      • Vertica Approach
      • Vertica Storage model
      • Find the largest table in Vertica database
      • Find the space used by a vertica table
      • system table for all Table objects
      • Find the version of Vertica
Simple theme. Powered by Blogger.