Which is better join or subquery?
No Answer is Posted For this Question
Be the First to Post Answer
How does pl sql work?
What are stored procedures in mysql?
What is a record in a database?
What is the cause of mutating table error and how can we solve it?
Why does %isopen return false for an implicit cursor?
Why are indexes and views important to an organization?
Which type of cursor is used to execute the dml statement?
What is a delimiter in sas?
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.
I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
How do you retrieve the last N records from a table?
what is the use of set statement in tsql? : Transact sql