Can we use distinct and group by together?
No Answer is Posted For this Question
Be the First to Post Answer
Where the Pre_defined_exceptions are stored ?
explain the difference between myisam static and myisam dynamic. : Sql dba
Why join is faster than subquery?
What is use of term?
What is an escape character in sql?
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)
how to get a list of columns in an existing table? : Sql dba
What are the rules to be applied to nulls whilst doing comparisons?
Explain what is rdbms?
What is TABLE SPACE?
what is difference between pass by value and eference by value in oracle plsql