guys plz help me
plz answer that 5th question
computer science (python programming language)
unwanted answers will be reported
Attachments:
Answers
Answered by
0
Explanation:
Subscribe This Channel in youtube I will follow you and mark u brainliest Channel Name - Cherry Blossom 2008
Answered by
0
Answer:
i)
fetchall() and fetchone() are the methods used in Python to retrieve rows from a SQL database.
cursor.fetchone() method returns a single record or None if no more rows are available whereas cursor.fetchall() fetches all the rows of a query result. It returns all the rows as a list of tuples. An empty list is returned if there is no record available to fetch.
Examples: Refer to the attachment.
ii)
To delete the duplicate rows from the table in SQL Server:
- Find duplicate rows using GROUP BY clause or ROW_NUMBER() function.
- Use DELETE statement to remove the duplicate rows.
Attachments:
Similar questions
Music,
2 months ago
Hindi,
5 months ago
English,
5 months ago
English,
10 months ago
Social Sciences,
10 months ago