Can we make the the chages By Using the Sql
if u know any function or process please inform me
Actuall result:
BRK1 Break 1 Part 1 00:01:00:00 60
BRK1 Break 1 Part 2 00:01:00:00 60
BRK2 Break 2 Part 1 00:01:00:00 60
BRK2 Break 2 Part 2 00:01:00:00 60
BRK2 Break 2 Part 3 00:01:00:00 60
BRK3 Break 3 Part 1 00:01:00:00 60
BRK3 Break 3 Part 2 00:01:00:00 60
Desired O/P:
BRK1 Break 1 Part 1 00:01:00:00 60
Part 2 00:01:00:00 60
BRK2 Break 2 Part 1 00:01:00:00 60
Part 2 00:01:00:00 60
Part 3 00:01:00:00 60
No Answer is Posted For this Question
Be the First to Post Answer
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is the ‘fillfactor’?
What do you mean by cardinality?
Which tcl commands are available on the sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is order of B+tree?
How to Handle the exceptions in Sqlsrver 2005??
What are the transaction properties?
What is sql injection? How to protect against sql injection attack?
What is cdc in sql server?
What are the benefits of filtered indexes?
Oracle (3253)
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)