In SQL, which command is used to SELECT only one copy of each set of duplicate rows DBMS
Answer: SELECT DISTINCT
No Explanation Available.
Share this question with friends
In SQL, which command is used to add new rows to a table?
A particular DBMS uses SQL for extracting data. The SQL command "WHERE" is usually followed by:
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)
Which command is used to remove all rows from a table ?
Match SQL language with SQL commands1)DDL i)Revok, Grant2)DML ii)rename a table3)TCL iii)insert, update4)DCL iv)rollback , commit
In SQL, which command(s) is (are) used to change a table’s storage characteristics?
This is an authorization command of SQL
To remove a relation from an SQL database, we use the ______ command.
All DBMS systems use SQL as a command language.
Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?
SELECT statement is a ...............in SQL
SELECT * FROM employee WHERE dept_name="Comp Sci";In the SQL given above there is an error . Identify the error.
Which is the correct query to delete the rows of employees whose exp is less than 10.
Which of these rows absolutely CANNOT be the primary key?
Which one of the following command is used to delete the existing row in a table?
Intersection of rows and columns is called ..........
The statement in SQL which allows to change the definition of a table is
Which SQL statement would add a record to the database?
Count function in SQL returns the number of