Create a table Student with (Stud_id, Name, Age, Address, Grade). Solve queries in SQL: Find records of Students from city 'Pune'.
Understand the Problem
The question involves creating a table for a student database using SQL, and it requires solving specific queries based on that table. The user seems to be looking for assistance with database creation and SQL query formulation.
Answer
SELECT * FROM Student WHERE Address LIKE '%Pune%';
SQL query: SELECT * FROM Student WHERE Address LIKE '%Pune%';
Answer for screen readers
SQL query: SELECT * FROM Student WHERE Address LIKE '%Pune%';
More Information
This query selects all students whose address contains the city 'Pune'. The LIKE operator is used with '%' to handle partial matches.
Tips
Ensure the column name is correctly spelled and the value is wrapped in quotes.
AI-generated content may contain errors. Please verify critical information
Thank you for voting!
