Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT
- list_ims.name AS NAME
- FROM
- measuring,
- list_ims,
- test_name,
- test_variant,
- party_ims
- WHERE
- (
- measuring.id_test_variant = test_variant.id AND test_variant.id_test_name = test_name.id
- ) AND(
- measuring.id_party = party_ims.id AND party_ims.id = list_ims.id
- ) AND test_name.name = "Выходное напряжение низкого уровня UOL, В"
- name_1
- name_2
- SELECT DISTINCT
- list_ims.name AS NAME
- FROM
- measuring,
- list_ims,
- test_name,
- test_variant,
- party_ims
- WHERE
- (
- measuring.id_test_variant = test_variant.id AND test_variant.id_test_name = test_name.id
- ) AND(
- measuring.id_party = party_ims.id AND party_ims.id = list_ims.id
- ) AND test_name.name = "Выходное напряжение высокого уровня UOH, В"
- name_1
- name_2
- SELECT
- list_ims.name AS names_ims
- FROM
- measuring,
- list_ims,
- test_name,
- test_variant,
- party_ims
- WHERE
- (
- measuring.id_test_variant = test_variant.id AND test_variant.id_test_name = test_name.id
- ) AND(
- measuring.id_party = party_ims.id AND party_ims.id = list_ims.id
- ) AND test_name.name IN(
- "Выходное напряжение низкого уровня UOL, В",
- "Выходное напряжение высокого уровня UOH, В",
- 'Ток потребления ICC, мА'
- )
- HAVING COUNT(names_ims) = 3
- SELECT list_ims.name AS NAME
- FROM measuring,
- list_ims,
- test_name,
- test_variant,
- party_ims
- WHERE measuring.id_test_variant = test_variant.id
- AND test_variant.id_test_name = test_name.id
- AND measuring.id_party = party_ims.id
- AND party_ims.id = list_ims.id
- AND test_name.name IN ( 'Выходное напряжение низкого уровня UOL, В',
- 'Выходное напряжение высокого уровня UOH, В',
- 'Ток потребления ICC, мА' )
- GROUP BY list_ims.name
- HAVING 3 = COUNT( /* DISTINCT */ test_name.name)
Add Comment
Please, Sign In to add comment