I am writing a select query like that "select Data from table1 where 1d=1
" that will return me output like that
id Data
1 10
now i want output like that
id Temp Data
1 2 10
the query "select '2',Data from table1 where 1d=1" give me the required output.But when database return null It should be like that
id Temp Data
1 2 null
But it will return 0 row.Kindly tell me the query to get the required output . Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire