how to get the name field of a record when given the id

Question

I have a query:

SELECT Id, recordtypeid  FROM myObject__c  

but instead of returning the recordtype id, i want to return the recordtype name. How do i do that?

Answer 1

Select Id, RecordType.Name from myObject__c