Question:What will happen if you query the emp table as shown below:
select empno, DISTINCT ename, Salary from emp;
 

A EMPNO, unique value of ENAME and then SALARY are displayed 

B EMPNO, unique value ENAME and unique value of 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 

+ Answer
+ Report
Total Preview: 652

Copyright © 2024. Powered by Intellect Software Ltd