#SQLTip - Tagar Twitter

3 bulan yang lalu

SQL for absolute beginners: Never use SELECT * in real projects! Instead: SELECT customer_name, order_date, amount FROM sales WHERE region = 'North' LIMIT 50; Cleaner, faster, and professional. Your future boss will thank you 😂 Reply 'SQL' if you learnt something new #SQLTip

dev_awizee's tweet photo. SQL for absolute beginners:
Never use SELECT * in real projects!

Instead: SELECT customer_name, order_date, amount FROM sales WHERE region = 'North' LIMIT 50;

Cleaner, faster, and professional.

Your future boss will thank you 😂

Reply 'SQL' if you learnt something new
#SQLTip https://t.co/10KXCsV7Yj

1

26

4

6

554

The Analyst @dev_awizee

4 bulan yang lalu

Quick poll for beginners What's your biggest struggle right now? A) Cleaning messy Excel data B) Understanding SQL JOINs C) Learning Python basics D) Building first Power BI dashboard Vote and reply with your choice Let's help each other grow #DataAnalysis #SQLTip #PowerBI

0

2

1

0

93

Auwal Musa @auwal_musam

lebih dari 2 tahun yang lalu

Deep dive into the interconnected world of SQL! 🌐🔗 Gain mastery over joining multiple tables. It's like piecing together a puzzle, each piece revealing a part of your data's story. Cherish the process 🧩 #DataScience #SQLTip

0

2

Franck Pachot @FranckPachot

hampir 3 tahun yang lalu

#SQLTip: Ignore the SQL definition of isolation levels and understand how to lock rows explicitly (with an example for geeks 🤓) https://t.co/6t1tRVl90e

0

20

3

9

2K

ChistaDATA Inc. @chistadata

sekitar 3 tahun yang lalu

Mastering Conditional Analysis with ClickHouse's IS Operator! Check out our latest blog post for real-life applications and insights. #SQLTip #ClickHouse #ConditionalAnalysis #DataInsights #DataScience https://t.co/jU8TQw9yGz

chistadata's tweet photo. Mastering Conditional Analysis with ClickHouse's IS Operator! Check out our latest blog post for real-life applications and insights. #SQLTip #ClickHouse #ConditionalAnalysis #DataInsights #DataScience https://t.co/jU8TQw9yGz https://t.co/dgqVVWnfIG

0

2

0

58

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: When writing queries, order rows by the most frequently accessed fields first. This will make your joins faster and more efficient. #Programming #SQL

khemsok97's tweet photo. #SQLTip: When writing queries, order rows by the most frequently accessed fields first. This will make your joins faster and more efficient. #Programming #SQL https://t.co/aPPqt2A4AV

0

2

1

0

18

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: To find the most recent entries in a table, add ORDER BY <column_name> DESC to your SELECT statement. #programming #database

khemsok97's tweet photo. #SQLTip: To find the most recent entries in a table, add ORDER BY <column_name> DESC to your SELECT statement. #programming #database https://t.co/uHxauSvMGE

0

2

1

0

4

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: Simplify your queries & improve database performance by properly using JOINS. Always start by thinking about the most efficient way to join tables. #Programming #SoftwareEngineer

khemsok97's tweet photo. #SQLTip: Simplify your queries & improve database performance by properly using JOINS. Always start by thinking about the most efficient way to join tables. #Programming #SoftwareEngineer https://t.co/wSVr7oDO8O

0

2

1

0

66

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: To retrieve only distinct records from a table, use the SELECT DISTINCT statement. This can help save loads of time! #Programming

khemsok97's tweet photo. #SQLTip: To retrieve only distinct records from a table, use the SELECT DISTINCT statement. This can help save loads of time! #Programming https://t.co/rMD4EN2Kuu

0

2

0

81

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: Use subqueries to reduce the complexity of your joins & queries. It'll save you time & help you get the desired result faster! #Coding #Programming

khemsok97's tweet photo. #SQLTip: Use subqueries to reduce the complexity of your joins & queries. It'll save you time & help you get the desired result faster! #Coding #Programming https://t.co/8Kbp5RcJ9p

0

2

1

0

4

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: To optimize a query, use the EXPLAIN command to get an understanding of the query execution plan & identify inefficiencies. #programming #SQL

khemsok97's tweet photo. #SQLTip: To optimize a query, use the EXPLAIN command to get an understanding of the query execution plan & identify inefficiencies. #programming #SQL https://t.co/cNMeQMy3IN

0

3

1

0

24

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: Need to find values between two numbers? Use the BETWEEN keyword to find records that fit a certain criteria. #Programming

khemsok97's tweet photo. #SQLTip: Need to find values between two numbers? Use the BETWEEN keyword to find records that fit a certain criteria. #Programming https://t.co/JTsLIW2xs7

0

2

1

0

8

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: Create meaningful aliases for table and column names to simplify your queries and make your code easier to read and understand. #programming

khemsok97's tweet photo. #SQLTip: Create meaningful aliases for table and column names to simplify your queries and make your code easier to read and understand. #programming https://t.co/ua6JoTGG8x

0

2

1

0

4

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: Use “EXPLAIN” to analyze lengthy queries. It helps you understand what is happening under the hood and determine if there are any issues. #Database #Programming

khemsok97's tweet photo. #SQLTip: Use “EXPLAIN” to analyze lengthy queries. It helps you understand what is happening under the hood and determine if there are any issues. #Database #Programming https://t.co/rFw6WdMqHh

0

2

1

0

5

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip - Use UNION to join results from two or more SQL queries into a single table. Faster and more efficient than using subqueries. #Programming

khemsok97's tweet photo. #SQLTip - Use UNION to join results from two or more SQL queries into a single table. Faster and more efficient than using subqueries. #Programming https://t.co/BCySYmqkdS

0

2

1

0

6

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: When using JOIN in a query, add an ORDER BY clause at the end. It will help you sort your results and make them easier to work with. #Programming

khemsok97's tweet photo. #SQLTip: When using JOIN in a query, add an ORDER BY clause at the end. It will help you sort your results and make them easier to work with. #Programming https://t.co/Q75lGRtVt6

0

3

1

0

21

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: Use subqueries to run one query inside another query. This is a great way to get the data you need from multiple tables #programming

khemsok97's tweet photo. #SQLTip: Use subqueries to run one query inside another query. This is a great way to get the data you need from multiple tables #programming https://t.co/NXmGxscVEA

0

2

1

0

11

khem 👨‍💻 @khemsok97

lebih dari 3 tahun yang lalu

#SQLTip: Avoid using string literals for sql commands. Use parameterized queries for improved protection from SQL injection attacks! #programming

khemsok97's tweet photo. #SQLTip: Avoid using string literals for sql commands. Use parameterized queries for improved protection from SQL injection attacks! #programming https://t.co/RXghj4YUGU

0

2

1

0

19

Estrada Web Group @EstradaWebGroup

lebih dari 3 tahun yang lalu

¡Mantén integridad de datos en tus consultas #SQL! Aprende a usar claves foráneas (FOREIGN KEY) 🔗💪https://t.co/CXMrEEtqUp #SQLTricks #SQLTip #SQLQuery

0

15

3

0

6K

Estrada Web Group @EstradaWebGroup

lebih dari 3 tahun yang lalu

¿Buscas combinar varias cadenas de texto en una sola en #SQLServer? ¡Prueba la función 🧐 CONCAT! https://t.co/5R88SlykgC 💡 #SQLTip #SQLQuery #SQLMadeEasy

0

13

1

0

6K

Tweet Teratas untuk #SQLTip

Tagar Terakhir Terlihat di Sotwe

Tren untuk Anda

Pengguna Paling Populer