Answer Posted / chakri
Hi friend,
In the above Select statement 1 is constant so it will
display with respect to the other columns infromation
Result for ur query:
column_heading no_col col2_2 col3_3
1 name1 3000
1 name2 2000
in this way it will display the result.
Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
Does access use sql?
What are sql functions? Describe in brief different types of sql functions?
what are the advantages of mysql in comparison to oracle? : Sql dba
What is snowflake sql?
what is a record in a database ? : Sql dba
Which join is like inner join?
explain advantages of innodb over myisam. : Sql dba
How does postgresql compare to oracle/db2/ms sql server/informix?
What is sqlite used for?
describe mysql connection using mysql binary. : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What are the two types of cursors in pl sql?
What are instead of triggers?
define join and explain different type of joins? : Sql dba
What is the trigger in sql?