Can we use distinct and group by together?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Where the Pre_defined_exceptions are stored ?

2 Answers  


explain the difference between myisam static and myisam dynamic. : Sql dba

0 Answers  


Why join is faster than subquery?

0 Answers  


What is use of term?

0 Answers  


What is an escape character in sql?

0 Answers  






What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,


Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,


how to get a list of columns in an existing table? : Sql dba

0 Answers  


What are the rules to be applied to nulls whilst doing comparisons?

0 Answers  


Explain what is rdbms?

0 Answers  


What is TABLE SPACE?

4 Answers   ABB, TCS,


what is difference between pass by value and eference by value in oracle plsql

1 Answers  


Categories