Home/ Questions/Q 1005
Answered
Ask The Science
  • 1
Asked: 2022-12-18T01:05:26+05:30

If a table contains duplicate rows, will a query display duplicate values by default? How can you eliminate duplicate rows from a query result?

  • 1

If a table contains duplicate rows, will a query display duplicate values by default? How can you eliminate duplicate rows from a query result?

interview questionssql interview questions
Share

    1 Answer

    1. Best Answer

      Yes, they will be displayed by default. To eliminate duplicate records, you use the DISTINCT keyword after the word SELECT.

      • 1

    You must login to add an answer.

    Need An Account,