Loading
what will be the result of this query :Select 1 from a table.
6 Answers
1
AshishPosted Apr 22, 2014, 6:57 AM
this query returns one column with all the rows data as 1, for no.of rows present in that table
vijay vanamPosted Jan 1, 2010, 7:48 AM
this query returns one column with all the rows data as 1 for no.of columns present in that table
vijay vanamPosted Jan 1, 2010, 7:47 AM
Hello
'select 1 from tablename ' will show
1
1
1
1
1
till no of rows in that particular table
Jimmy VyasPosted Jul 2, 2007, 5:50 AM
It will returns one column with 1 as result in each row.
hema 0Posted May 9, 2007, 8:37 AM
represents the value as result on each row of the table
giri prasadPosted May 7, 2007, 4:04 AM