What is rank () in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is the requirement of self-join?
what is an associative array with example?
What is a sql instance vs database?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Explain what is a subquery ?
What is foreign key in sql with example?
What operators deal with null?
Mention what are the benefits of pl/sql packages?
What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
What is dynamic SQl and how you will create and execute dynamic sql?
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
What is difference between stored procedures and application procedures?
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)