What will happen if you query the EMP table shown in question 2 with - ProProfs Discuss
Topics
Products
Follow Us:

What will happen if you query the EMP table shown in question 2 with the following?
SELECT empno, DISTINCT ename, salary FROM emp;



A. EMPNO, unique values of ENAME and then SALARY are displayed.
B. EMPNO, unique values of the two columns, ENAME and SALARY, are displayed
C. DISTINCT is not a valid keyword in SQL
D. No values will be displayed because the statement will return an error.

This question is part of Oracle_Test6
Asked by Sudha_test, Last updated: Mar 21, 2020

+ Answer
Request

1 Answer

sudha_test

Sudha_test

Answered Nov 18, 2017

No values will be displayed because the statement will return an error.
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.