Welcome to TDBSoverflow, Our class's own StackOverflow. Our rules:
  1. Use only meaningful and self-explanatory titles
  2. Tag your questions with meaningful keywords
  3. Use upvotes and downvotes to rate the answers
  4. When you receive a satisfying answer - Click the "V" button
Remember: you may get up to 5 bonus points to your final grade!

Using the LIMIT Keyword in Exercise #1

+9 votes
87 views
In the important notes it says "Do not use the LIMIT keyword" and you explain that by giving this example:

"there may be tens of rows in the result, and you should return them all"

Can I use the LIMIT keyword to get the first line of the table, when I know that I'm not loosing any lines at the answer.

Thanks
asked Nov 9, 2017 by lavikazar (570 points)
edited Nov 10, 2017 by Amit
Hi, note that I edited your title to be more meaningful. Please post only self-explanatory and meaningful title from now on ok?  (this is for the benefit of all users)

1 Answer

+1 vote
 
Best answer
As mentioned in the instructions, using the LIMIT keyword in the homework exercise is not allowed.

If you want to get the first row without using LIMIT, you can order it by a suitable attribute, then pick the MIN or the MAX (Or any other way you want, just dont use limit)
answered Nov 10, 2017 by Amit (27,910 points)
selected Nov 10, 2017 by lavikazar
...