Database Analyst Question: Download Database Analyst PDF
Tell us what do you use to get non-repeated values?
Answer:
The DISTINCT keyword is used in the SELECT statement to eliminate repetition of identical data. It is also used in aggregate functions. When DISTINCT is used with only one column or expression, the query will strictly return the unique values for that particular column or expression. Similarly, when DISTINCT is used with multiple columns or expressions, the query will return only the unique combinations of those columns or expressions. Note that the DISTINCT keyword doesn’t ignore the NULL value when sifting through data.
| Previous Question | Next Question |
| Explain few of the best tools useful for data analytics? | Tell me which data analysis software are you well-versed in? |