Need a solution for this problem

• tvrarundeepak

  SSC Enthusiast

  Points: 147

  More actions

  July 28, 2018 at 9:25 am

  #358866

  Hi All,
     I need a solution for this problem please help me

  First Create table like below query
  create table people (Firstname varchar(50),FamilyName varchar(50),City varchar(50))
  then 
  insert value like Arun, Don, Chennai
  insert value like Hema, Don, Chennai
  insert value like Kumar, Don, Chennai

  I need to display one row for above three rows for that i need a query please help me.

• Joe Torre

  SSChampion

  Points: 10248

  More actions

  July 28, 2018 at 8:09 pm

  #1999377

  Post:

  • Create table statement
  • Insert statements with sample data
  • What you have tried
  • Errors or explanation of how the result was incorrect
  • What output you are trying to get from the sample data you have posted