PDA

View Full Version : Write in SQL query . What are the full names of students who have the...

tribal_ripgurl
05-25-2007, 11:28 PM
...same surname? write in SQL query? table: studentcolumns: fname, Lname
Serge M
05-30-2007, 09:43 AM
select fname + '' + lnamefrom student s1where EXISTS (select 1from student s2 where s1.lname = s2.lnameand s1.fname s2.fname)
www.sql-ex.ru (http://www.sql-ex.ru/)