why does the selected column have to be in the group by clause or part of an agg

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

Question Posted / akash yadav

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

More SQL PLSQL Interview Questions

What is the importance of sqlcode and sqlerrm?

How the execution will be done in exceptions?

How global cursor can be declare with dynamic trigger ?

Explain dml and ddl?

how to check the 3rd max salary from an employee table?

Write a query to get 2nd maximum salary in an employee table ?

Types of locks in database ?

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

Give an example of Full Outer Join?

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

Can instead of triggers be used to fire once for each statement on a view?

For more SQL PLSQL Interview Questions Click Here