what is the difference between truncate and drop statements? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 Answers IBM, Loginworks, OFSS,
Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
How long will it take to learn pl sql?
what is difference b/w pravite procedures and public procedures?
3 Answers Steria, Wipro, Zensar,
What is trigger in pl sql?
How can I change database name in sql?
What pl/sql package consists of?
can i use global variables in stored procedure or function
how to fetch alternate records from a table? : Sql dba
Why do we use sql constraints?
What is a left inner join?
What is blind sql injection?
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)