Computer Science, asked by s2060sanjana01476, 5 months ago

guys plz help me
plz answer that 5th question
computer science (python programming language)

unwanted answers will be reported ​

Attachments:

Answers

Answered by bernespereira
0

Explanation:

Subscribe This Channel in youtube I will follow you and mark u brainliest Channel Name - Cherry Blossom 2008

Answered by Anonymous
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:

  1. Find duplicate rows using GROUP BY clause or ROW_NUMBER() function.
  2. Use DELETE statement to remove the duplicate rows.

Attachments:
Similar questions