fork download
copy 
  1. CREATE TABLE CosineTable
  2. (
  3. Angle int(2),
  4. CosValue decimal(5, 4)
  5. );
  6.  
  7. INSERT INTO CosineTable (Angle, CosValue) VALUES 
  8. (0,1),
  9. (5,0.9962),
  10. (10,0.9848),
  11. (15,0.9659),
  12. (20,0.9397),
  13. (25,0.9063),
  14. (30,0.866), 	
  15. (35,0.8192),
  16. (40,0.766),
  17. (45,0.7071),
  18. (50,0.6428),
  19. (55,0.5736),
  20. (60,0.5),
  21. (65,0.4226),
  22. (70,0.342),
  23. (75,0.2588),
  24. (80,0.1736),
  25. (85,0.0872),
  26. (90,0);
  27.  
  28. -- SELECT angle FROM CosineTable WHERE (cosvalue = max(angle < 73));
  29. SELECT CosValue FROM CosineTable WHERE (angle = (SELECT max(angle) FROM CosineTable WHERE Angle < 73));
  30. SELECT CosValue FROM CosineTable WHERE (angle = (SELECT min(angle) FROM CosineTable WHERE Angle > 73));
  31. SELECT max(Angle) FROM CosineTable WHERE Angle < 73;
  32. SELECT min(Angle) FROM CosineTable WHERE Angle > 73;
  33.  
  34.  
  35. SELECT
  36. (
  37. 	(
  38. 		SELECT CosValue FROM CosineTable WHERE (angle = (SELECT max(angle) FROM CosineTable WHERE Angle < 73))
  39. 	) 
  40. 		+
  41. 	(
  42. 		(
  43. 			SELECT CosValue FROM CosineTable WHERE (angle = (SELECT min(angle) FROM CosineTable WHERE Angle > 73))
  44. 		) 
  45. 			-
  46. 		(
  47. 			SELECT CosValue FROM CosineTable WHERE (angle = (SELECT max(angle) FROM CosineTable WHERE Angle < 73))	
  48. 		)
  49. 	)
  50. 		*
  51. 	(
  52. 		73 
  53. 			-
  54. 		(
  55. 			SELECT max(Angle) FROM CosineTable WHERE Angle < 73
  56. 		)
  57. 	) 
  58. 		/ 
  59. 	(
  60. 		(
  61. 			SELECT min(Angle) FROM CosineTable WHERE Angle > 73
  62. 		) 
  63. 			-
  64. 		(
  65. 			SELECT max(Angle) FROM CosineTable WHERE Angle < 73
  66. 		)
  67. 	)
  68. );
  69.  
Success #stdin #stdout #stderr 0s 3452KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
0.342
0.2588
70
75
stderr
copy 
Error: near line 35: near ";": syntax error
Error: near line 59: near "(": syntax error
https://ideone.com/LVrOOK
language:
SQLite (sqlite 3.27.2)
created:
7 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!