Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Valid Email Addresses

Return the ids of users whose email address is valid: letters, digits or . _ % + - before the @, then a domain with at least one dot and a final part of two or more letters. Order by id.

Table schema

Users(id INT PRIMARY KEY, email VARCHAR(100))

Sample data

id | email
1 | a@x.com
2 | bad@
3 | @x.com
4 | c.d@y.co.in

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.