SQL Database [closed]

Question

SQL Database [closed]

Navigation

#1 by (4 votes)

-3

Hello! I'm in training in Support and I'm having a hard time understanding the logic of select, I need to do script for example: bring the statuses of the Criteria table.

sql select

asked by anonymous 30.08.2016 / 20:52

1 answer

How to make a progress bar of the PHP download [closed] Starting in C # language [closed]

score 4 · Answer 1

Your SQL would be this:

SELECT status FROM Critérios

The logic is as follows:

A query SELECT always produces a result table.
All records in the Critérios table are searched. No filter is applied, and therefore all records are returned (if you wanted to filter, a WHERE clause would be required). Each record found will correspond to one row of the table.
The column status of the records obtained is selected. You could select more columns, but since you're only selecting this, your table will contain only the status column and nothing else.
As a result, you will have a list of all statuses in the Critérios table. There may be repetitions if several different records of the Critérios table have the same status .