SQL example to testing data

From Catglobe Wiki
Revision as of 09:00, 29 April 2009 by Catglobe (talk | contribs)
Jump to: navigation, search

Version 5.7

=============================
select top 10 Id, [name] from project_questionnaire_resource
where [name] like '%minh_questionnaire_For_testing%'

-- lay ve questionnaire id cua PQ do ==>> 14
select top 10 id, questionnaire_id from project_questionnaire
where id = 6059

-- lay ve cac question cua PQ do 
select top 100 q.id, label, sub_question_count, question_type 
from question q, questionnaire_question qq
where qq.questionnaire_id = 6384 and q.id = qq.question_id

-- lay ve cac answer option
select top 10 * from answer_option
where question_id = 273102

select id as 'rpqid',[user_id] from resource_project_questionnaire
where project_questionnaire_id = 6059 
order by id desc

-- lay ve answer 
select top 100 id,option_number,[value],answer_option_id,question_id,[user_id],resource_project_questionnaire_id from data
where resource_project_questionnaire_id = 20595510

select top 100 id,option_number,[value],answer_option_id,question_id,[user_id],resource_project_questionnaire_id from data
where resource_project_questionnaire_id = 20595517
select top 100 id,option_number,[value],answer_option_id,question_id,[user_id],resource_project_questionnaire_id from data
where resource_project_questionnaire_id = 20595518

Version 5.6

=============================

select top 10 Id, [name] from project_questionnaire_resource where [name] like '%minh_questionnaire_For_testing%'

-- lay ve questionnaire id cua PQ do ==>> 14 select top 10 id, questionnaire_id from project_questionnaire where id = 5344

-- lay ve cac question cua PQ do select top 100 q.id, label, sub_question_count, question_type from question q, questionnaire_question qq where qq.questionnaire_id = 5521 and q.id = qq.question_id

-- lay ve cac answer option select top 10 * from answer_option where question_id = 248685

select id as 'rpqid',[user_id] from resource_project_questionnaire where project_questionnaire_id = 5344 order by id desc

-- lay ve answer select top 100 id,option_number,[value],answer_option_id,question_id,[user_id],resource_project_questionnaire_id from data where resource_project_questionnaire_id = 18104527


select top 100 id,option_number,[value],answer_option_id,question_id,[user_id],resource_project_questionnaire_id from data where resource_project_questionnaire_id = 18104533 select top 100 id,option_number,[value],answer_option_id,question_id,[user_id],resource_project_questionnaire_id from data where resource_project_questionnaire_id = 18104534


Version 5.5

=============================

select top 10 Id, [name] from project_questionnaire_resource where [name] like '%minh_questionnaire_For_testing%'

-- lay ve questionnaire id cua PQ do ==>> 14 select top 10 id, questionnaire_id from project_questionnaire where id = 5038

-- lay ve cac question cua PQ do select top 100 q.id, label, sub_question_count, question_type from question q, questionnaire_question qq where qq.questionnaire_id = 5142 and q.id = qq.question_id

-- lay ve cac answer option select top 10 * from answer_option where question_id = 212547


-- lay ve answer select top 100 id,option_number,[value],answer_option_id,question_id,[user_id],resource_project_questionnaire_id from data where resource_project_questionnaire_id = 15785316


select top 10 * from data_open where data_id = 127194938


-- lay ve questionnaire nao co nhiu rpqid nhat


select top 100 count(id),project_questionnaire_id from resource_project_questionnaire group by project_questionnaire_id order by count(id) desc

Retrieved from "http://wiki.catglobe.com/index.php?title=SQL_example_to_testing_data&oldid=6145"