Diference between Select Query in Sql (select * from TblPerson) and (select Name,Age from TblPerson)hi Developers i have a simple doubt in Ado.Net
i have a table named TblPerson
and i have the following column
i want to show Name and Age From the TblPerson Table
in this case i have two options
1.select * from TblPerson or (where Some Conditions)
2.select Name,Age from TblPerson or (where Some Conditions)
if i use 1-st one i will get all the records. so no need 2-nd option.
but some people using 2-nd Option like
select Name,Age from TblPerson or (where Some Conditions)
instead if first query we can get our expected output. then why peoples using 2-nd option.
so i van guess they having a valid reason. but
i can't able to understand the exact reason
so please friends please clarify my doubt. if my question is incorrect don't take mistake me
Prayer throw, Impossible becomes Possible.