What are the differences between in and exists clause?
No Answer is Posted For this Question
Be the First to Post Answer
How do I run sql profiler?
In a package if we have 10 procedures or functions,How to know which will execute first?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent
Is natural join and inner join same?
What are records give examples?
Is inner join faster than left join?
Define commit, rollback and savepoint?
how can we find the number of rows in a table using mysql? : Sql dba
How can I see all tables in sql?
What is implicit cursor in pl sql?
Can a select statement fire a trigger?
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)