select 1,col1,col2 from table1. output?

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


Please Help Members By Posting Answers For Below Questions

Does access use sql?

567


What are sql functions? Describe in brief different types of sql functions?

494


what are the advantages of mysql in comparison to oracle? : Sql dba

533


What is snowflake sql?

582


what is a record in a database ? : Sql dba

570






Which join is like inner join?

567


explain advantages of innodb over myisam. : Sql dba

649


How does postgresql compare to oracle/db2/ms sql server/informix?

574


What is sqlite used for?

533


describe mysql connection using mysql binary. : Sql dba

555


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

676


What are the two types of cursors in pl sql?

543


What are instead of triggers?

628


define join and explain different type of joins? : Sql dba

548


What is the trigger in sql?

542