If you want a column to be part of the result set, after
which SQL keyword does it belong?
1. SELECT
2. FROM
3. WHERE
4. GROUP BY
5. HAVING
- 10 Answers
- 17911 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / j.t.karthikeyan
The word result set is nothing but aggregation.
GROUP BY is the right answer.
Result set like Groupin, Grouping SETS etc...
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What does pl sql stand for?
What are all the different types of indexes?
Is grant a ddl statement?
What is data types in sql?
Explain scalar functions in sql?
How do I view a table in sql?
What are the different types of sql commands?
Why is sql important?
How many tables can a sql database have?
how to create a new view in mysql? : Sql dba
What is the max nvarchar size?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is sql partition?
What is a file delimiter?
What are tables and fields in the database?
