I read some articles but really didn't understand what does select 1 from
do? Someone says "you should use select 1
instead of select *
". Here is an example table:
cust_id cust_name cust_address
1000000001 Village Toys Mapl
1000000002 Kids Place South
1000000003 Fun4All Sunny
1000000004 Fun4All Riverside
1000000005 The Toy Store 53rd
What will the result be when I write select 1 from customer_table
what does this statement do?