Get Recordtype Name Using SOQL Query

Sample Code:

SELECT Id, Name, RecordType.Name From Contact