Hi friend, In the above Select statement 1 is constant so it will displ

select 1,col1,col2 from table1. output?

Question Posted / chakri

5 Answers
10219 Views
Ramco, I also Faced
E-Mail Answers

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

define sql update statement ? : Sql dba

1048

Is postgresql a nosql database?

1072

Explain normalization and what are the advantages of it?

890

What are the methods of filing?

871

What is group function in sql?

960

What are the types of dbms?

918

Is foreign key mandatory?

938

how to start mysql server? : Sql dba

1141

What is Materialized View? In What Scenario we Use Materialized View?

9392

What are the two characteristics of a primary key?

926

Is sql better than access?

961

What is the maximum size of sqlite database?

1039

What is example of database?

983

What is the primary use of normalization?

937

How does left join work in sql?

938