Questions tagged [sql]
Structured Query Language (SQL) is a language for querying databases. Questions should include code examples, table structure, sample data, and a tag for the DBMS implementation (e.g. MySQL, PostgreSQL, Oracle, MS SQL Server, IBM DB2, etc.) being used.
4
questions
145
votes
13
answers
97k
views
Why do people prefer Pandas to SQL?
I've been using SQL since 1996, so I may be biased. I've used MySQL and SQLite 3 extensively, but have also used Microsoft SQL Server and Oracle.
The vast majority of the operations I've seen done ...
20
votes
5
answers
17k
views
Do modern R and/or Python libraries make SQL obsolete?
I work in an office where SQL Server is the backbone of everything we do, from data processing to cleaning to munging. My colleague specializes in writing complex functions and stored procedures to ...
- 363
26
votes
5
answers
36k
views
Natural Language to SQL query
I have been working on developing a system "Converting Natural Language to SQL Query".
I have read the answers from the similar questions, but was not able to get the information that I was looking ...
- 1,441
3
votes
1
answer
271
views
How do write the following piece of code in R?
I am trying to write a piece of code for R to fetch data from an api with the following command:
...
- 1,091