Guest User

Untitled

a guest
Oct 18th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. SELECT DISTINCT
  2. list_ims.name AS NAME
  3. FROM
  4. measuring,
  5. list_ims,
  6. test_name,
  7. test_variant,
  8. party_ims
  9. WHERE
  10. (
  11. measuring.id_test_variant = test_variant.id AND test_variant.id_test_name = test_name.id
  12. ) AND(
  13. measuring.id_party = party_ims.id AND party_ims.id = list_ims.id
  14. ) AND test_name.name = "Выходное напряжение низкого уровня UOL, В"
  15.  
  16. name_1
  17. name_2
  18.  
  19. SELECT DISTINCT
  20. list_ims.name AS NAME
  21. FROM
  22. measuring,
  23. list_ims,
  24. test_name,
  25. test_variant,
  26. party_ims
  27. WHERE
  28. (
  29. measuring.id_test_variant = test_variant.id AND test_variant.id_test_name = test_name.id
  30. ) AND(
  31. measuring.id_party = party_ims.id AND party_ims.id = list_ims.id
  32. ) AND test_name.name = "Выходное напряжение высокого уровня UOH, В"
  33.  
  34. name_1
  35. name_2
  36.  
  37. SELECT
  38. list_ims.name AS names_ims
  39. FROM
  40. measuring,
  41. list_ims,
  42. test_name,
  43. test_variant,
  44. party_ims
  45. WHERE
  46. (
  47. measuring.id_test_variant = test_variant.id AND test_variant.id_test_name = test_name.id
  48. ) AND(
  49. measuring.id_party = party_ims.id AND party_ims.id = list_ims.id
  50. ) AND test_name.name IN(
  51. "Выходное напряжение низкого уровня UOL, В",
  52. "Выходное напряжение высокого уровня UOH, В",
  53. 'Ток потребления ICC, мА'
  54. )
  55. HAVING COUNT(names_ims) = 3
  56.  
  57. SELECT list_ims.name AS NAME
  58. FROM measuring,
  59. list_ims,
  60. test_name,
  61. test_variant,
  62. party_ims
  63. WHERE measuring.id_test_variant = test_variant.id
  64. AND test_variant.id_test_name = test_name.id
  65. AND measuring.id_party = party_ims.id
  66. AND party_ims.id = list_ims.id
  67. AND test_name.name IN ( 'Выходное напряжение низкого уровня UOL, В',
  68. 'Выходное напряжение высокого уровня UOH, В',
  69. 'Ток потребления ICC, мА' )
  70. GROUP BY list_ims.name
  71. HAVING 3 = COUNT( /* DISTINCT */ test_name.name)
Add Comment
Please, Sign In to add comment