I can not solve first sentence in transformation table


#1

Hello. I can not solve first sentence in transformation table
"Select ten rows from the flights table " can you pls help me? thx


SQL :Table transformation
#2

Hi Robert,

What do you think would be a sensible first guess at doing that?


#3

3 posts were split to a new topic: Why is this giving me an incomplete error?


#4

i have had trouble with that too i still cant answer it


#5

Hi,

Think about this.

I have four friends and we all want to play on the PS3 but there are only 2 PS3 controllers to play. So only only 2 players are allowed to play at one time.

So in the problem out of the 100+ rows you are only asked to display 10 rows at one time.

Here's the link for practice: https://www.codecademy.com/en/courses/learn-sql/lessons/queries/exercises/limit?action=lesson_resume


#6

SELECT * FROM flights LIMIT 10;


#7

I am having trouble with this one as well, I tried that line of code and it did not work, any suggestions


#8

well, actually it did work after I copied and pasted it, must have misspelled something, thank you


#9

Missing a semicolon. Notice that :relieved:


#10

remove first SELECT * FROM flights;
tap SELECT *FROM flights LIMIT 10;


#11

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.