SQL query for getting data in two fields from one column.
- by AmiT
I have a table [Tbl1] containing two fields.
ID as int And
TextValue as nvarchar(max)
Suppose there are 7 records. I need a resultset that has two columns Text1 and Text2.
The Text1 should have first 4 records and Text2 should have remaining 3 records.
[Tbl1]
ID | TextValue
1. | Apple
2. | Mango
3. | Orange
4. …