0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

SELECT TOP 10 
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],  
    Id, 
    Reputation, 
    Location 
FROM 
    Users 
WHERE 
    LOWER(Location) LIKE '%india%' 
    OR UPPER(Location) LIKE '%INDIA' 
    AND LOWER(Id) LIKE '%prav%'
ORDER BY 
    Reputation DESC;

fork query

edited feb 6

created feb 6 Vikas