What does over partition by mean in sql?
No Answer is Posted For this Question
Be the First to Post Answer
How can you get sql*loader to commit only at the end of the load file? : aql loader
Why truncate is faster than delete?
How would you hide a table in sql. ie the table can be only visible to its maker?
What are advantages of Stored Procedures?
How do I get sql certification?
What is the difference between left and left outer join?
how do you know if your mysql server is alive? : Sql dba
What is primary key and unique key?
What is the most restrictive isolation level? : Transact sql
Types of cursor locks and explanation each of them ?
what are pl/sql collections?
4 Answers JPMorgan Chase, Oracle,
Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --
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)