SQL Shorts - SELECT DISTINCT Statement (Learn new SQL Concepts in 5 minutes)

-

  • The SELECT DISTINCT statement is used to only return distinct or unique values in a particular selected column.
 Syntax:

SELECT DISTINCT column_name

FROM table_name

Examples:

Q). Find distinct names of people from the city Onionpur

Here, the query can be as follows:

SELECT DISTINCT names

FROM Onionpur

Q) Select distinct names from the table: students

Here, our query can be as follows:

SELECT DISTINCT name

FROM students

Points to remember:

  • DISTINCT is used to select unique values in a column.


 

Comments

Post a Comment

Popular posts from this blog

How to clear the Alteryx Designer Core Certification Exam in Two Weeks

-
 Alteryx is basically a software that extracts information from raw data, converts into a format that fulfills business requirements and then loads it into a target system. Alteryx is used by many companies these days because of its ability to build data models, and that too without requiring the knowledge of any programming language. So, basically we have three exams here: Alteryx Designer Core Alteryx Designer Advanced Alteryx Designer Expert Now, I'll be discussing about how to clear the Alteryx Designer Core Certification here. The best way for it is as follows: Interactive lessons on Alteryx Community: Here, go through the lessons labelled as 'Core', as for now. The link for it is:  Interactive Lessons Alteryx learning path: Do go through the learning path for tutorials. The link to it is:  Learning Path Alteryx Core Certification prep guide: This is a whole package on 'How to prepare for Alteryx Designer Core Certification'. This well help you the most in your
Read more

Current Affairs - 15 April 2021 - Current Affairs for General Knowledge and also to prepare for competitive exams

-
 Oberoi group has recently signed an MoU with EESL (Energy Efficiency Services Limited). It is a joint venture of four PSUs (Public Sector Undertaking) under the Ministry of Power. Syska LED has won a tender to supply 10 million LED blubs in rural areas, under the Gram Ujala scheme, to Energy Efficiency Services Ltd's subsidiary CESL (Convergence Energy Services Limited. The World Bank Group entity IFC (International Finance Corporation) is partnering with JC Flowers. US based GIP (Global Infrastructure Partners') Indian green energy platform, Vector Green Energy plans to raise Rs 1237 crores through a green bond in the Indian capital market. The IMPCL (Indian Medicines Pharmaceutical Corporation Limited), the public sector manufacturing unit of the Ministry of AYUSH has recorded a turnover of Rs 164.33 cr in 2020-21. The European Union is expecting 50 million Pfizer COVID-19 vaccine doses earlier than expected, as the United States would continue to pause vaccinations in Johns
Read more

Current Affairs - 12 June 2021 - Daily Current Affairs for general knowledge and to prepare for competitive exams

-
 Biotech company Mylab Discovery Solutions has appointed Akshay Kumar as their brand ambassador. Swami Shivamayanandaji, the vice-president of Ramakrishna Math and Mission, had passed away in June 2021. Deep down in the ocean, marine sediments move over the base of the ocean, shaping the probability of geohazards. Scientists tracing the concentration, size, and evolution of aerosol particles smaller than 3 nm at an urban location in India have found the frequent formation of sub-3nm aerosol particles in the atmosphere. 3 indian startups have been selected to undertake joint R&D and technology transfer projects under the India-Russia joint technology assessment and accelerated commercialization program. CSIR - Council of Scientific and Industrial Research, and Laxai Life Sciences Pvt. Ltd., have been given regulatory approval from the Drugs Controller General of India. Ajinkya Investment and Trading Co., has sold a 1% equity stake in Bharat Forge Ltd, via an open market transaction.
Read more