Datagrip - get row count (easily) on queries with more than 500 results
Is there a way (setting or shortcut) for displaying the total row count of a query that outputs more than 500 rows - that is, without modifying the "Result set page size" value in preferences? I'm looking essentially for the output of select count(*) from (<query>) t in addition to the displayed rows.
Solution
Click on page-size of the result-set
- how to copy a table from one postgres db to another in datagrip?
- DataGrip: Cannot apply changes This table is read only. Cell editor changes cannot be applied
- How to connect to MongoDB with certificate using DataGrip?
- javax.net.ssl.SSLHandshakeException: The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]
- suppress/eliminate datagrip sql reformatting for nested selects
- Connecting Jetbrains Datagrip to DB2 Version 7.5 encoding error
- How to connect to database through SSH using DataGrip
- DataGrip: database connection with multiple schemas
- How to disable auto-format in DataGrip
- IntelliJ: Run command before opening DB connection. How to achieve it with kubectl port-forward?
- Generating sql insert into for DataGrip
- Is there a postgis geometry viewer in JetBrains DataGrip?
- DataGrip - show full table name in tabs and elsewhere
- Sort Result Set in Data View by Multiple Columns
- How jump to value in INSERT statement in IntelliJ IDEA query console?
- Filtering the list of tables in JetBrains Datagrip
- Datagrip - get row count (easily) on queries with more than 500 results
- How to set the settings in DataGrip SQL code style editor so that the join conditions are on separate lines?
- Fixed the timezone issue from nextJS API fetching from aws redshift
- How to save my formatting of MySQL stored procedure?
- DataGrip added value compared to IntelliJ IDEA
- How to quick view tables in DataGrip?
- How to quickly generate SELECT statement with all columns for a table in DataGrip?
- How to make DataGrip default to using Manual transactions?
- Transaction across changes in multiple tables
- How do I connect JetBrains DataGrip to CockroachDB Serverless?
- IntelliJ IDEA Data Grip - NotSerializableException: com.oracle.truffle.api.TruffleStackTraceElement in MongoDB query
- Jetbrains DataGrip cannot add a new SQL Server connection without specifying a concrete database
- how to show un-committed changes in a database table in datagrip
- How to Export/Import a Data Source from DataGrip?