SET 1

SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

[{"selector":"#anim-31ecedd4-2307-4134-ab82-c2b093453ad8","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-08b74d3c-98d6-4af1-a3e3-6586ddde1c75","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-b688f7fc-ed1d-4fe5-b34c-1f02af4ba51f","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-9556d6fd-b34a-4ac7-a992-123a69a1456f","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":1000,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-af58be9d-56f3-45c2-bb08-7e7f88f15ecd","keyframes":{"opacity":[0,1]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-135b946e-9bca-4c3a-8b18-8cf23c68687c","keyframes":{"transform":["translate3d(0px, 218.71353%, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-db569c24-169b-4db8-8581-58e4ee2e8e70","keyframes":[{"offset":0,"transform":"translate3d(0, -303.01139%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"translate3d(0, -85.206802868%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -28.967888884%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"translate3d(0, -10.878108901000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -4.7269776839999995%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}]

If we want to allow age of a person > 18 in the column Age of table Person, then which constraint will be applied to AGE column.

[{"selector":"#anim-06db660b-98c1-4730-badb-92581f8ee773","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-cd3b25ff-432a-4b82-8a77-f179152e30bd","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-c41dcd65-9de9-495e-89bc-f5423900bddf","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-bc06c2ac-f3d0-4552-bc2a-a71c7ced4cdf","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":1000,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-057a346c-e4bf-4c44-a52a-7da3e23fc24d","keyframes":{"opacity":[0,1]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-45822e28-3037-4271-8dee-e703c29a218d","keyframes":{"transform":["translate3d(0px, 274.39601%, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3d76b03c-01c1-4bc4-ba7f-71adb6bed22e","keyframes":[{"offset":0,"transform":"translate3d(0, -303.01139%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"translate3d(0, -85.206802868%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -28.967888884%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"translate3d(0, -10.878108901000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -4.7269776839999995%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}]

In a table, a column contains duplicate value, if you want to list all different value only, then which SQL clause is used?

[{"selector":"#anim-9160ee12-3883-44ed-846e-5a93d89f3b20","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-9ac58c81-4759-4096-95c4-d32c0b56f384","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-b0109519-a52a-443b-b62b-9c1fe2ff2044","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-e656fd73-81f0-40dd-8f7e-5baeddeac81a","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":1000,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-5c3df633-7889-4f47-9ebb-8a7b40ddff83","keyframes":{"opacity":[0,1]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9b91f946-1219-42a2-8dd5-a7b550c5462a","keyframes":{"transform":["translate3d(0px, 302.98117%, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5e78b8b8-1fba-4962-bd9d-6fcafaa0c292","keyframes":[{"offset":0,"transform":"translate3d(0, -303.01139%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"translate3d(0, -85.206802868%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -28.967888884%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"translate3d(0, -10.878108901000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -4.7269776839999995%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}]

To give a temporary name to a table, or a column in a table for more readability, what is used?

[{"selector":"#anim-488e5e23-28f2-4f1c-b8f0-a9e28fc7d879","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-6c7f382a-65d6-4796-ac2d-c410427279b0","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-467b9788-cb26-4d2c-881f-e6b1b55f5fa2","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-2e3d3821-3d94-46e8-af58-716a544e62d3","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":1000,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-b836cd57-aaf2-435f-bf5a-d63c8cfe9212","keyframes":{"opacity":[0,1]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b43e69d6-173a-481c-8f10-45d218702640","keyframes":{"transform":["translate3d(0px, 302.98117%, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a5c2d5cc-f4f4-4a06-a261-64d1ab3be49a","keyframes":[{"offset":0,"transform":"translate3d(0, -303.01139%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"translate3d(0, -85.206802868%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -28.967888884%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"translate3d(0, -10.878108901000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -4.7269776839999995%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}]

Logical operators used in SQL are

[{"selector":"#anim-7694c82f-3019-435f-b45f-b08f12dc25ba","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-7e4635f6-0a5f-4c16-b0c3-f7e1c1f1367f","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-b0fcd89e-0a8a-46b1-a588-ba4e1e042435","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-4819275b-1cc9-41b7-b3dc-9ff0054bb055","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":1000,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-994bebdd-b71e-4c6a-b1ed-970d5c8a653d","keyframes":{"opacity":[0,1]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fb0590b2-f8c4-4b21-9f87-2a75f8ee3617","keyframes":{"transform":["translate3d(0px, 302.98117%, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f406d8bd-23c2-4f4b-8828-01ff8bcb9879","keyframes":[{"offset":0,"transform":"translate3d(0, -303.01139%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"translate3d(0, -85.206802868%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -28.967888884%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"translate3d(0, -10.878108901000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -4.7269776839999995%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}]

To specify the number of records to return, which keyword is used

[{"selector":"#anim-1d117210-70be-4bf5-857f-f5420537b888","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-b9a520ca-1ee6-445b-a783-36abdda7364a","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-0735c4a5-afd7-4723-a88b-07d80b7f8d40","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-1f3c66a4-f0a1-48a1-8b2f-696ed4961e26","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":1000,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-814d532b-51f8-4596-b950-cb929903a066","keyframes":{"opacity":[0,1]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e7e4a74e-f69b-4aa1-a02a-94bdd98530ca","keyframes":{"transform":["translate3d(0px, 302.98117%, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-95c0dfd2-bdce-4e47-85c7-a2c05df2d561","keyframes":[{"offset":0,"transform":"translate3d(0, -303.01139%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"translate3d(0, -85.206802868%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -28.967888884%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"translate3d(0, -10.878108901000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -4.7269776839999995%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}]

To search for a specified pattern in a column

[{"selector":"#anim-3156397f-3262-49a2-a027-c53a3b305b9e","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-d3b66b3b-2707-4bb8-bfff-8822572cd1a3","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-360346ca-5a0f-47e6-af13-6cf9ff478b5f","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-296c10b5-03e2-4628-b963-478776d3d2c0","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":1000,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-e8115f5c-f22a-4ae4-b5db-f593cd039604","keyframes":{"opacity":[0,1]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-490f6984-f1be-4ca5-b58a-c83cd29d6cb8","keyframes":{"transform":["translate3d(0px, 302.98117%, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-676f9829-f4be-4f1a-b34f-95f8eff3044f","keyframes":[{"offset":0,"transform":"translate3d(0, -303.01139%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"translate3d(0, -85.206802868%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -28.967888884%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"translate3d(0, -10.878108901000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -4.7269776839999995%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}]

To combine the result-set of two or more SELECT statements, SQL clause used is

[{"selector":"#anim-96b62e0d-3f5b-4fd2-9af2-d5f675bfe199","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-6502a4b1-645b-4883-b823-0cac6e49c96d","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-9cfaba0c-4552-4b0c-8bc1-082a17238012","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-91cb9228-39d7-48b4-9f93-b23a7750b0e2","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":1000,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-9d77a26d-910a-4121-a6ed-f5d36dc60d01","keyframes":{"opacity":[0,1]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5e9a5426-58c7-4caf-a195-36dfe3ae5a48","keyframes":{"transform":["translate3d(0px, 302.98117%, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-87c3f498-9fea-4b10-a792-de2293cad9b9","keyframes":[{"offset":0,"transform":"translate3d(0, -313.29173%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"translate3d(0, -88.097634476%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -29.950689387999997%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"translate3d(0, -11.247173107%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -4.887350988%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}]

Which is called as a virtual table in SQL?

[{"selector":"#anim-3ee0d3ed-11e7-4f1b-8759-92232ec15931","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-a2a40bc3-decb-40a0-aa41-a476b1d74c59","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-79b79ee8-4c39-4549-9027-ae043936b139","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-4beab84f-3023-46f3-b7c8-2fa93d17fc1e","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":1000,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-3e66cb3c-1cfb-443c-b274-9773a8de6876","keyframes":{"opacity":[0,1]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-12e48234-5338-4e81-81d8-340d5efc4efa","keyframes":{"transform":["translate3d(0px, 302.98117%, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9f577e62-9537-4f27-bae2-1ae0a62a1c6f","keyframes":[{"offset":0,"transform":"translate3d(0, -313.29173%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"translate3d(0, -88.097634476%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -29.950689387999997%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"translate3d(0, -11.247173107%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -4.887350988%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}]

The SQL join which does Cartesian product is called?

[{"selector":"#anim-2641f8da-26b9-4647-9cdd-5caa1db24e01","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-98c1beb9-2b95-4fef-bbcc-0837fb461817","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-71a5aad4-f335-4905-a408-ea48b9f7fdb5","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-e26c85ab-4d01-47c0-a77a-e3401a536f4f","keyframes":[{"transform":"scale(1)","offset":0},{"transform":"scale(1.5)","offset":0.330000000000000015543122344752191565930843353271484375},{"transform":"scale(0.95)","offset":0.66000000000000003108624468950438313186168670654296875},{"transform":"scale(1)","offset":1}],"delay":1000,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}] [{"selector":"#anim-b378bd37-404c-449c-acd6-fd102051046d","keyframes":{"opacity":[0,1]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-dfac61ed-065c-42f7-aafd-ddc9007ed8cc","keyframes":{"transform":["translate3d(0px, 344.44463%, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1366b9ef-7f35-4818-b030-71d395bc1896","keyframes":[{"offset":0,"transform":"translate3d(0, -313.29173%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"translate3d(0, -88.097634476%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -29.950689387999997%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"translate3d(0, -11.247173107%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -4.887350988%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}]

[{"selector":"#anim-d5cab6d7-2a74-49c8-a79a-4b6eb07a2e34","keyframes":[{"offset":0,"transform":"translate3d(0, -189.39187%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"translate3d(0, -53.25699384400001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -18.105862772000002%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"translate3d(0, -6.799168133000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"translate3d(0, -2.954513172%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}] [{"selector":"#anim-834b9fa7-6b59-4818-ab66-b9dee9b681b8","keyframes":[{"offset":0,"transform":"rotate(-88deg) translate3d(0, -499.2521%, 0) rotate(88deg)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.289999999999999980015985556747182272374629974365234375,"transform":"rotate(-88deg) translate3d(0, 0%, 0) rotate(88deg)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.450000000000000011102230246251565404236316680908203125,"transform":"rotate(-88deg) translate3d(0, -140.38969052%, 0) rotate(88deg)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.60999999999999998667732370449812151491641998291015625,"transform":"rotate(-88deg) translate3d(0, 0%, 0) rotate(88deg)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.70999999999999996447286321199499070644378662109375,"transform":"rotate(-88deg) translate3d(0, -47.72850076%, 0) rotate(88deg)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8000000000000000444089209850062616169452667236328125,"transform":"rotate(-88deg) translate3d(0, 0%, 0) rotate(88deg)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.84999999999999997779553950749686919152736663818359375,"transform":"rotate(-88deg) translate3d(0, -17.92315039%, 0) rotate(88deg)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92000000000000003996802888650563545525074005126953125,"transform":"rotate(-88deg) translate3d(0, 0%, 0) rotate(88deg)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.95999999999999996447286321199499070644378662109375,"transform":"rotate(-88deg) translate3d(0, -7.788332759999999%, 0) rotate(88deg)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"rotate(-88deg) translate3d(0, 0%, 0) rotate(88deg)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}] Arrow SQL

SET 1

SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

GOEDUHUB.COM

DELETE FROM table_name

2

If we want to allow age of a person > 18 in the column Age of table Person, then which constraint will be applied to AGE column.

GOEDUHUB.COM

Check

3

In a table, a column contains duplicate value, if you want to list all different value only, then which SQL clause is used?

GOEDUHUB.COM

SQL DISTINCT

4

To give a temporary name to a table, or a column in a table for more readability, what is used?

GOEDUHUB.COM

SQL DISTINCT

5

Logical operators used in SQL are

GOEDUHUB.COM

AND, OR , NOT

7

To specify the number of records to return, which keyword is used

GOEDUHUB.COM

TOP

8

To search for a specified pattern in a column

GOEDUHUB.COM

SQL LIKE

9

To combine the result-set of two or more SELECT statements, SQL clause used is

GOEDUHUB.COM

SQL UNION

10

Which is called as a virtual table in SQL?

GOEDUHUB.COM

VIEW

11

The SQL join which does Cartesian product is called?

GOEDUHUB.COM

Cross Join

14