Can we use distinct and group by together?
No Answer is Posted For this Question
Be the First to Post Answer
what is not null constraint? : Sql dba
What is Referential Integrity?
select 10 from dual; y its showing all the rows with 10?
What is data types in sql?
What is bulk compiling in pl/sql.?
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
How do I run a sql query?
Can you upgrade sql express to full sql?
How do you get all records from 2 tables. Which join do you use?
Differentiate pl/sql and sql?
What is the use of function in sql?
What does cursor do in sql?