Treehouse | Community | Removing Specific Rows

🤑 Join the Treehouse affiliate program and earn 25% commission!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Vaidas Staugaitis
1,431 Points
Auto incremented ID after deleting rows

Posted March 26, 2017 4:59pm by Vaidas Staugaitis

Vaidas Staugaitis
1,431 Points
1 Answer
Malaya Manjula
6,028 Points
What am i doing wrong here

Posted March 25, 2017 11:19pm by Malaya Manjula

Malaya Manjula
6,028 Points
- Databases
1 Answer
Byron Injeeli
Full Stack JavaScript Techdegree Graduate 25,639 Points
Challenge - "count number of orders with status of shipped and shipped date as today". My result is 149.

Posted March 25, 2017 5:22pm by Byron Injeeli

Byron Injeeli
Full Stack JavaScript Techdegree Graduate 25,639 Points
- Databases
1 Answer
Eric Thomas
Front End Web Development Techdegree Student 3,689 Points
I need help with concatenate and combining columns.

Posted March 25, 2017 12:31pm by Eric Thomas

Eric Thomas
Front End Web Development Techdegree Student 3,689 Points
- Databases
1 Answer
Eric Johansen
1,685 Points
I keep getting a syntax error on this code; SELECT mk.MakeID, v.VIN, sp.StickerPrice FROM Model AS md INNER JOIN make AS

Posted March 24, 2017 8:06pm by Eric Johansen

Eric Johansen
1,685 Points
- Databases
0 Answers
Joel McCracken Jr
3,142 Points
Relational Database Challenge Task 2 of 5: Bummer ambiguous column name Car.VIN

Posted March 24, 2017 6:44pm by Joel McCracken Jr

Joel McCracken Jr
3,142 Points
- Databases
3 Answers
PLUS

Emily Coltman
Courses Plus Student 9,623 Points
What am I doing wrong with the Querying Relational Databases final practice session, please?

Posted March 24, 2017 4:37pm by Emily Coltman

Emily Coltman
Courses Plus Student 9,623 Points
- Databases
5 Answers
Jonatan Spahn
6,362 Points
SQL Stage 4: Practice problem.

Posted March 24, 2017 4:47am by Jonatan Spahn

Jonatan Spahn
6,362 Points
3 Answers
Jan Lundeen
5,886 Points
Getting a "AS" syntax error for a query counting the number of orders shipped today [uses DATE("now")].

Posted March 24, 2017 4:26am by Jan Lundeen

Jan Lundeen
5,886 Points
- Databases
3 Answers
Benjamin Everett
5,401 Points
Updating Data with SQL - code challenge - why is this not working?

Posted March 23, 2017 8:17pm by Benjamin Everett

Benjamin Everett
5,401 Points
- Databases
1 Answer
Jonatan Spahn
6,362 Points
Average of each movie

Posted March 23, 2017 12:58am by Jonatan Spahn

Jonatan Spahn
6,362 Points
3 Answers
Abhilasha jangid
2,925 Points
what function use to get word starting with the letters A through K

Posted March 22, 2017 3:08pm by Abhilasha jangid

Abhilasha jangid
2,925 Points
- Databases
1 Answer
Inbar Shimshon
2,286 Points
Hi, not sure what is wrong with my code: https://www.screencast.com/t/uUNfukYrxbv I am using an Insert statement...

Posted March 22, 2017 9:44am by Inbar Shimshon

Inbar Shimshon
2,286 Points
- Databases
1 Answer
PLUS

tonypitkin2
Courses Plus Student 1,950 Points
Can you combine a Substring and Replace function inside one another?

Posted March 22, 2017 12:10am by tonypitkin2

tonypitkin2
Courses Plus Student 1,950 Points
2 Answers
Jan Lundeen
5,886 Points
On SQL Playground, Stage 3, Practice, how do I calculate the average movie rating and round it to 1 decimal place?

Posted March 21, 2017 11:51pm by Jan Lundeen

Jan Lundeen
5,886 Points
3 Answers
Erica Rottman
2,602 Points
This keeps throwing an error SELECT first_name, last_name FROM users WHERE username = "wig-lady";

Posted March 21, 2017 6:21pm by Erica Rottman

Erica Rottman
2,602 Points
- Databases
1 Answer
Abhilasha jangid
2,925 Points
is a keyword that can be used in conjunction with LIMIT to page through results.

Posted March 21, 2017 6:00am by Abhilasha jangid

Abhilasha jangid
2,925 Points
1 Answer
Jonatan Spahn
6,362 Points
SQL exchange ratae problem

Posted March 21, 2017 4:23am by Jonatan Spahn

Jonatan Spahn
6,362 Points
- Databases
0 Answers
chingkang yi
Python Web Development Techdegree Student 16,111 Points
SELECT * FROM results WHERE home_team > 12; I don't understand why it's wrong.

Posted March 21, 2017 12:45am by chingkang yi

chingkang yi
Python Web Development Techdegree Student 16,111 Points
- Databases
2 Answers
Matt Caminiti
3,466 Points
Only showing first result from "WHERE" clause.

Posted March 20, 2017 10:24pm by Matt Caminiti

Matt Caminiti
3,466 Points
- Databases
2 Answers
Matt Caminiti
3,466 Points
Using INSERT INTO

Posted March 20, 2017 7:24pm by Matt Caminiti

Matt Caminiti
3,466 Points
- Databases
2 Answers
Wiley Conte
9,618 Points
Looks like I've got this address formatted correctly.

Posted March 20, 2017 2:59pm by Wiley Conte

Wiley Conte
9,618 Points
- Databases
3 Answers
hamilton katsvairo
6,306 Points
Reporting with SQL,Challenge task 2 of 2

Posted March 20, 2017 6:07am by hamilton katsvairo

hamilton katsvairo
6,306 Points
- Databases
2 Answers
Karrerah White
10,118 Points
SQL basics: Categorizing your output with 'AS'

Posted March 20, 2017 1:30am by Karrerah White

Karrerah White
10,118 Points
- Databases
2 Answers
Abhilasha jangid
2,925 Points
Expecting results like 'L Chalkley' not 'L Chalkley'.

Posted March 19, 2017 6:48pm by Abhilasha jangid

Abhilasha jangid
2,925 Points
- Databases
2 Answers
Cayo Estevao
2,048 Points
Why location id is = 1?

Posted March 19, 2017 2:18pm by Cayo Estevao

Cayo Estevao
2,048 Points
1 Answer
Christopher Johnson
2,066 Points
Why am I receiving "no such column: street" ?

Posted March 19, 2017 2:30am by Christopher Johnson

Christopher Johnson
2,066 Points
- Databases
2 Answers
SINAN LIN
2,254 Points
Can't access data file in DDMS. What should I do?

Posted March 19, 2017 1:02am by SINAN LIN

SINAN LIN
2,254 Points
- Databases
0 Answers
Jan Lundeen
5,886 Points
Calculating average ratings for Starman - Getting an error that the movie_id column doesn't exist.

Posted March 18, 2017 10:07pm by Jan Lundeen

Jan Lundeen
5,886 Points
- Databases
1 Answer
Sambath Phum
4,089 Points
Database: how to remove more than one actors?

Posted March 18, 2017 6:19am by Sambath Phum

Sambath Phum
4,089 Points
3 Answers

Prev Page 68 of 388 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.