Back to feeds

Payal Manghnani

Stealthย โ€ขย 1m

Day 4: Sorting Data with ORDER BY Hey guys, letโ€™s make your SQL queries even more powerful with ORDER BY! This command helps you sort your resultsโ€”either ascending (default) or descending. Example: SELECT name, age FROM Students ORDER BY age DESC; ๐ŸŽฏ This lists students from oldest to youngest. Mini Challenge: Using an Employees table, how would you list employees by salary in ascending order? Share your query below! Tomorrow, weโ€™ll dive into aggregating data with COUNT, AVG, and more. Stay tuned!

0 replies1 like

More like this

Recommendations from Medial

Payal Manghnani

Stealthย โ€ขย 1m

Day 3: Filtering Data with WHERE Guys, ready to take your SQL game up a notch? Today, letโ€™s talk about the WHERE clauseโ€”itโ€™s your tool to filter data like a pro! Hereโ€™s how it works: SELECT name, age FROM Students WHERE age > 18; ๐ŸŽฏ This gi

See More
1 replies3 likes

Payal Manghnani

Stealthย โ€ขย 1m

Now, letโ€™s kickstart our SQL journey with the SELECT statement! SELECT is like the spotlightโ€”it helps you pick and display specific data from a table. Hereโ€™s a quick example: SELECT name, age FROM Students; ๐ŸŽฏ This fetches the name and age of a

See More
0 replies3 likes
Anonymous

EPFO (employees have control over their data) If the login credentials are compromised, employee data can be accessed by anyone. It is essential for the employees to have control to their data. Only the employees should be allowed to enter their dat

See More
0 replies2 likes
1
Image Description

Payal Manghnani

Stealthย โ€ขย 6m

Here are some essential SQL topics for data analysts: 1. Basic Queries: SELECT, FROM, WHERE clauses. 2. Sorting and Filtering: ORDER BY, GROUP BY, HAVING. 3. Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN. 4. Aggregation Functions: COUNT, SUM, AVG, MIN, M

See More
1 replies4 likes
1
Image Description

Keshav Agarwal

Stealthย โ€ขย 8m

IDEA Validation Prob & Opportunity - Companies are spending infrastructure and funds on raw material , staff and etc on daily lunch meals of employees Solution A platform where there are let's say 10 meal combinations and companies can register on

See More
1 replies3 likes
1
Anonymous
Image Description
Image Description

Today I'm traveling by train in Indian Railways I noticed in my coach 3A there are 10-15 families with small kids and they are making noise of crying and it is really annoying coz travel time is 36 hrs so I think can we do with this problem and solve

See More
18 replies13 likes
Image Description
Image Description

Chandni Das

Stealthย โ€ขย 5m

I was thinking something in the morning, can something like this be done? I want modifications from you can give suggestions Interactive learning app for kids and students: - English, math, life skills, and values - Logical games, cartoon videos, a

See More
8 replies4 likes
Image Description
Image Description

Tanay Bhadade

Stealthย โ€ขย 9m

I'm developing a platform that connects busy students and professionals who crave home-cooked meals with home cooks looking to earn extra income. Many students and employees living away from home struggle to find healthy, affordable, and delicious m

See More
19 replies13 likes
1
Image Description
Image Description

SHIV DIXIT

Stealthย โ€ขย 9m

I think everyone has some disorders , doubt , introvert problem and trauma by opening psychiatrist clinic in all over India with US grade facilities then it will become profitable business and most of the students , employees and women's are living w

See More
4 replies6 likes
1
Image Description
Image Description

Siddhi Sharma

Stealthย โ€ขย 9m

I'm a 2yr College student and recently one idea came in my mind which is basically a food app, like Zomato and swiggy which will only cater to need of college students , it will have list of canteens which are on college campus only, the customers wi

See More
18 replies14 likes
2

Download the medial app to read full posts, comements and news.