What is meant by truncate in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is pl/sql table? Why is it used?
what is sql and plsql
What is the use of prepared statement?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is the syntax and use of the coalesce function?
Can we use ddl statements in stored procedure?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is use of trigger?
What is auto increment?
Can we use ddl statements in stored procedure sql server?
How do you retrieve the last N records from a table?
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
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)