Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL DISTINCT

The PostgreSQL DISTINCT keyword is used in conjunction with SELECT statement to eliminate all the duplicate records and fetching only unique records.
There may be a situation when you have multiple duplicate records in a table. While fetching such records, it makes more sense to fetch only unique records instead of fetching duplicate records.
postgres=# SELECT name FROM tab1;           
 name  
-------
 nijam
 abu
 umar
 jamal
 abu
(5 rows)
-- From above table  tab1 having one duplicate values "name=ABU" is duplicate so DISTINCT  clause used to show without duplicate values. 
postgres=# SELECT DISTINCT(name) FROM tab1; 
 name  
-------
 umar
 jamal
 nijam
 abu
(4 rows)













Comments

Post a Comment

Popular posts from this blog

Pgbadger Feature In Postgresql

1. pgBadger reports everything about your SQL queries            Overall statistics            The most frequent waiting queries.            Queries that waited the most.            Queries generating the most temporary files.            Queries generating the largest temporary files.            The slowest queries.            Queries that took up the most time.            The most frequent queries.            The most frequent errors.            Histogram of query times.            Histogram of sessions times.            Users involved in top queries.            Applications involved in to...
Read more

ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info ->>'PRODUCTS' ->>'produc... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

postgres=# select * from sales; id | sales_info ----+---------------------------------------------------------------------------------- 1 | { "customer": "NIJAM", "PRODUCTS": {"product_name": "choclate","total_item": 6}} 2 | { "customer": "ABU", "PRODUCTS": {"product_name": "badam","total_item": 5}} 3 | { "customer": "UMAR", "PRODUCTS": {"product_name": "mobile","total_item": 1}} (3 rows) postgres=# SELECT sales_info ->>'customer' as customer_name,sales_info ->>'PRODUCTS' ->>'product_name' as name_of_product from sales where sales_info ->>'customer'='UMAR'; ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info -...
Read more

rman interview and scenario based questions and answer and also rman(backup and recovery) discussions panel

set 1 1.What is RMAN? Recovery Manager (RMAN) is a utility that can manage your entire Oracle backup and recovery activities. 2.What is the difference between using recovery catalog and control file?  When new incarnation happens, the old backup information in control file will be lost. It will be preserved in recovery catalog. In recovery catalog we can store scripts.  Recovery catalog is central and can have information of many databases. 3.Can we use same target database as catalog?      No, The recovery catalog should not reside in the target database (database should be backed up), because the database can’t be    recovered in the mounted state. 4.How do you know that how much RMAN task has been completed?    By querying v$rman_status or v$session_longops 5.From where list & report commands will get input? Both the commands command quering v$ and recovery catalog views. V$BACKUP_FILES or many of the recovery catalog views such as RC_...
Read more

PostgreSQL Enterprise Manager - PEM Monitoring Tools

Image
Database administration and management is required for any database on which there are continuous business transactions.  If databases across enterprises are not monitored and maintained, then such databases are vulnerable to disasters, which eventually brings downtime to missions-critical application and, of course, it will incur losses in the business. Data is now one of the key assets for running a business, globally. Hence, it is one of the major responsibilities of enterprises to invest in resources for database monitoring and management. There are many database management and monitoring tools available for proactive database monitoring. In this article, we will look at  PEM – “PostgreSQL Enterprise Manager” .Enterprise Manager, or PEM, is a graphical database management/monitoring tool that can help database administrators, system administrators, database developers, database managers, system architects, and performance analysts manage databases efficiently and proacti...
Read more

How to Use netstat (network statistics) command In Linux

netstat  ( network statistics ) is a command line tool for monitoring network connections both incoming and outgoing as well as viewing routing tables, interface statistics etc.  netstat  is available on all Unix-like Operating Systems and also available on  Windows OS  as well. It is very useful in terms of network troubleshooting and performance measurement.  netstat  is one of the most basic network service debugging tools, telling you what ports are open and whether any programs are listening on ports. This tool is very important and much useful for Linux network administrators as well as system administrators to monitor and troubleshoot their network related problems and determine network traffic performance. This article shows usages of  netstat  command with their examples which may be useful in daily operation. You might also be interested in following article How to work Linux Find Command 1. Listing all the LISTENING Po...
Read more