in sql table follw columns r their
vehicle_no|servicetype|date|location|
1234 |1FS |1-JAN|PUNE|
4561 |2FS |5-JAN|PUNE|
1234 |PS |7-JAN|PUNE|
1234 |PS |15-JAN|MUMB|
i want o/p below
vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS
DATE|2PSLOCA
e.g
1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI
PLS help me out to execute using sql query
- 1 Answers
- 2407 Views
- I also Faced
- E-Mail Answers
Answer Posted / mathivanan
select listagg(vehicle_no||'|'||servicetype||'|'||date||'|'||location,'|') within group (order by vehicle_no) from table_name
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is t sql a programming language?
How exception is different from error?
Advantages and disadvantages of stored procedure?
what are all the different types of indexes? : Sql dba
What is view? Can we update view
What information is needed to connect sql*plus an oracle server?
How do I quit sql?
Can we use ddl statements in stored procedure sql server?
How do I access sql anywhere database?
What is acid property in a database?
What is rank () in sql?
What is sql catalog?
What is before and after trigger?
How insert into statements in sql?
What is difference between function and trigger?
