4

I am using the following incredibly useful utility...

http://data.stackexchange.com

The following shows the posts started / answered by me.

select * from Posts where OwnerUserId = 139150  

How do I restrict the search only to the questions asked by me? I do not want to find the posts where I have written an answer.

1
  • 2
    Just in case you didn't know, you can also see your own questions in your profile
    – Brad Mace
    Jun 24 '11 at 5:30
4

You need to filter based on the PostTypeId. 1 is for questions.

select * from Posts where OwnerUserId = 139150 and PostTypeId = 1

2
  • Thanks. But this does not show the title. I do not want to select the "Body" column. How to get the title in the query.
    – shantanuo
    Jun 24 '11 at 5:43
  • 1
    @shantanuo This does show the title, but you need to scroll far to the right to find it. If you want just the title, change select * to select title. Also, there is a typo. OwnerUsedId needs to be changed to OwnerUserId.
    – ughoavgfhw
    Jun 24 '11 at 6:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .