Define a sql query? What is the difference between select and update query? How do you use sql in sas, python, r languages?
- 1 Answers
- 489 Views
- I also Faced
- E-Mail Answers
Answer Posted / Nupur Tandon
A SQL (Structured Query Language) query is a request for data from a relational database. It consists of a series of statements that define what data is needed, how it should be structured, and any conditions that need to be met. A SELECT query retrieves data from a database, while an UPDATE query modifies existing data in the database. SAS uses SQL through its PROC SQL procedure, Python uses libraries such as sqlite3 or pandas.DataFrame.read_sql_query(), and R uses libraries like RSQLite or dbConnect(). In these languages, you can write SQL queries to interact with your databases.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
