Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 21349 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
It is Select.
Bcoz
2) from : includes the table name (source and not columns)
3)Where : specifies the condition based on which the rows
are retrived
4) Group by : mentions the column on which the rows are to
be grouped.. note that the column name mentioned should
also be specified in the select clause
5) Having : not sure
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / avinash hiwarale
Select
it gives you the option to choose the column you want to
see.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / sathishrpillai
if you want a column to be a part of result set then it
SELECT
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / rampratap singh
After Select
because Result set is the feature of java and it will hold
a record (list of columns) from column clause only
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
How would you hide a table in sql. ie the table can be only visible to its maker?
How do you write a subquery?
Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.
What is a primary key? Explain
What is the difference between sum and count in sql?
what are the difference between clustered and a non-clustered index? : Sql dba
What is case function?
write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh
What are triggers and its types?
What view means?
What is the difference between delete and truncate statement in sql?
What is delimiter sql?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
