Diya Systems Interview Questions and Answers

Multiple Choice questions about Level 1 work. Output of programs or writing queries

Q1. About output of PHP program
Add your answer
Q2. SQL query to find entries based on last name
Ans. 
Use SELECT statement with WHERE clause and LIKE operator to find entries based on last name.
• Use SELECT statement to retrieve data from the table.

• Use WHERE clause to filter the data based on last name.

• Use LIKE operator with % wildcard to match any characters before or after the last name.

• Example: SELECT * FROM table_name WHERE last_name LIKE 'Smith%'
Answered by AI
Add your answer