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

what is not null constraint? : Sql dba

0 Answers  


What is Referential Integrity?

3 Answers  


select 10 from dual; y its showing all the rows with 10?

1 Answers  


What is data types in sql?

0 Answers  


What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,






SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  


How do I run a sql query?

0 Answers  


Can you upgrade sql express to full sql?

0 Answers  


How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,


Differentiate pl/sql and sql?

0 Answers  


What is the use of function in sql?

0 Answers  


What does cursor do in sql?

0 Answers  


Categories