what is the use of select hint in sql server? why they use?

hi amanueljoseph,

Databases store data for later retrieval. Do you know how that is achieved? It's the SELECT SQL command that does the job.
That's what it's all about, retrieving data from the database tables. It's part of the data manipulation language that is responsible for query the data from the database.

An SQL SELECT Example:

The "Persons" table:

P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger

Now we want to select the content of the columns named "LastName" and "FirstName" from the table above.

We use the following SELECT statement:

SELECT LastName,FirstName FROM Persons
The result-set will look like this:

LastName FirstName
Hansen Ola
Svendson Tove
Pettersen Kari

For more Refer these links
http://www.w3schools.com/sql/sql_select.asp
http://www.guru99.com/select-statement.html#jd2c4U77oR7O1EYH.99
http://learnsqltips.blogspot.in/2012/04/select-distinct-from-where-group.html

Thanks&Regards
rajeshkommireddy@gmail.com

amanueljoseph-9523, if this helps please login to Mark As Answer. | Alert Moderator

SELECT LastName,FirstName FROM Persons
The result-set will look like this:

LastName FirstName
Hansen Ola
Svendson Tove
Pettersen Kari

For more Refer these links
www.welookups.com/sql/sql_select.html

amanueljoseph-9523, if this helps please login to Mark As Answer. | Alert Moderator

i was alos facing some issues

https://www.livesupportaid.com/verizon-fios-pay-bill-online-ifixit/

amanueljoseph-9523, if this helps please login to Mark As Answer. | Alert Moderator