In SQL, which command is used to SELECT only one copy of each set of duplicate rows DBMS

  • SELECT DISTINCT
  • SELECT UNIQUE
  • SELECT DIFFERENT
  • ALL OF THE ABOVE
Answer: SELECT DISTINCT
888 students attemted this question.

Explanation

No Explanation Available.

Share this question with friends

Similar Questions

  1. In SQL, which command is used to add new rows to a table?

  2. A particular DBMS uses SQL for extracting data. The SQL command "WHERE" is usually followed by:

  3. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

  4. SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

  5. Which command is used to remove all rows from a table ?

  6. Match SQL language with SQL commands1)DDL i)Revok, Grant2)DML ii)rename a table3)TCL iii)insert, update4)DCL iv)rollback , commit

  7. In SQL, which command(s) is (are) used to change a table’s storage characteristics?

  8. This is an authorization command of SQL

  9. To remove a relation from an SQL database, we use the ______ command.

  10. All DBMS systems use SQL as a command language.

  11. Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?

  12. SELECT statement is a ...............in SQL

  13. SELECT * FROM employee WHERE dept_name="Comp Sci";In the SQL given above there is an error . Identify the error.

  14. Which is the correct query to delete the rows of employees whose exp is less than 10.

  15. Which of these rows absolutely CANNOT be the primary key?

  16. Which one of the following command is used to delete the existing row in a table?

  17. Intersection of rows and columns is called ..........

  18. The statement in SQL which allows to change the definition of a table is

  19. Which SQL statement would add a record to the database?

  20. Count function in SQL returns the number of

Comments

Add Your Review

Your email address will not be published.

Subscribe to Newsletter!

Subscribe to get latest updates and information.