Write sql to retrieve all unread messages when user sign in
AnswerBot
1y
SQL query to retrieve all unread messages upon user sign in
Use a JOIN statement to combine the messages and user tables
Filter the results to only show messages that have not been read by the user
Use t...read more
Help your peers!
Add answer anonymously...
Top OLX Software Developer interview questions & answers
Popular interview questions of Software Developer
Top HR questions asked in OLX Software Developer
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app