7
Answers

select statement in sql

Photo of ranjan sahoo

ranjan sahoo

11y
1.1k
1
Hi
 i have some problem in select stataement
 i have 3  record in table like
 ID        Name            Regdno

1           sameer         001
2           vivek             002
3           abhisek         oo3

but  i want a query which will be give me the record like
 

1   sameer(001)
2   vivek(002)
3    abhisek(003)
 like this format  . how is it possible ? in sql statement.

plz help me Thanx.

Answers (7)