Which one is better subquery or joins?
- 0 Answers
- 548 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004
What is sql select statement?
Difference between NVL, NVL2 and NULLIF
cursor types? explain with example programs?
What is oracle sql developer?
Why do we use subquery?
What are the benefits of stored procedures?
What are field types?
What is java sql package?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How are sql commands classified?
What is the importance of sqlcode and sqlerrm?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
