What are Clauses? 🤔
A clause in SQL is part of a query that lets you:
filter and analyze large amounts of data stored in the database with the customization query you prefer.
retrieve a set of records from the table.
specify a condition on a table’s columns or records.
Currently, Oxla supports SQL queries with the following clauses:
<style>
.buttons {
display: flex;
align-items: center;
margin-top: -3.5rem;
}
.button-5 {
margin-right: 1rem;
white-space: normal;
max-width: 250px;
align-items: center;
background-clip: padding-box;
background-color: #20bdff;
border: 1px solid transparent;
border-radius: 0.25rem;
box-shadow: rgba(0, 0, 0, 0.02) 0 1px 3px 0;
box-sizing: border-box;
color: #fff;
cursor: pointer;
display: inline-flex;
font-size: 16px;
justify-content: center;
line-height: 1.25;
height: 5rem;
padding: calc(0.875rem - 1px) calc(1.5rem - 1px);
position: relative;
text-decoration: none;
transition: all 250ms;
user-select: none;
-webkit-user-select: none;
touch-action: manipulation;
vertical-align: baseline;
width: auto;
z-index: 3;
}
.button-5 a {
display: none;
}
.button-5:hover,
.button-5:focus {
background-color: #351ad2;
box-shadow: rgba(0, 0, 0, 0.1) 0 4px 12px;
}
.button-5:hover {
transform: translateY(-1px);
}
.button-5:active {
background-color: #351ad2;
box-shadow: rgba(0, 0, 0, 0.06) 0 2px 4px;
transform: translateY(0);
}
@media (max-width: 600px) {
.buttons {
flex-direction: column;
}
}
</style>
<div class="buttons">
<a href="https://docs.oxla.com/from">
<button class="button-5">
FROM
</button>
</a>
<a href="https://docs.oxla.com/where">
<button class="button-5">
WHERE
</button>
</a>
<a href="https://docs.oxla.com/group-by">
<button class="button-5">
GROUP BY
</button>
</a>
<a href="https://docs.oxla.com/having">
<button class="button-5">
HAVING
</button>
</a>
<a href="https://docs.oxla.com/order-by">
<button class="button-5">
ORDER BY
</button>
</a>
<a href="https://docs.oxla.com/limit">
<button class="button-5">
LIMIT
</button>
</a>
<a href="https://docs.oxla.com/offset">
<button class="button-5">
OFFSET
</button>
</a>
</div>