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
- 490 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is meant by logistic regression?
For linear regression, what are some of the assumptions a data scientist is most likely to make?
What is f test?
What is meant by feature vectors?
How and by what methods data visualizations can be effectively used?
Differentiate between skewed and uniform distribution?
Explain eigenvalue and eigenvector
What is systematic sampling?
What’s the difference between pip and pip3?
What is logistic and linear regression? How do you treat multicollinearity and heteroscedasticity in regression?
What are the key elements of the statistical graphics?
Why we need ggplot?
-
AI Algorithms (74) - AI Natural Language Processing (96)
- AI Knowledge Representation Reasoning (12)
- AI Robotics (183)
- AI Computer Vision (13)
- AI Neural Networks (66)
- AI Fuzzy Logic (31)
- AI Games (8)
- AI Languages (141)
- AI Tools (11)
- AI Machine Learning (659)
- Data Science (671)
- Data Mining (120)
- AI Deep Learning (111)
- Generative AI (153)
- AI Frameworks Libraries (197)
- AI Ethics Safety (100)
- AI Applications (427)
- AI General (197)
- AI AllOther (6)
