Explain the difference between pairwise and non-pairwise comparisons in multiple column sub-queries.
What happens if we remove primary key from SQL table?
Latest Answer: Once the primary key is removed two things will happen:1. The clustered index is also removed which decreases performance and2. The table would then allow duplicate data to be inserted causing data corruption. ...
Display details of employees having same char at the star and end postition of their namelike abishikathis name have last character and first character is same
Latest Answer: select * from emp where substr(ename 1 1) like substr(ename -1 1) ...
if i have a Customer table with following datacust id custname1 A2 Band cars table with following datacar id cust id Model1 1 Toyota2 1
Latest Answer: select * Customer,Carwhere Customer.custID=Car.custID; ...
what is dual table which is used as a table in sql...
Latest Answer: Every database contains only one dual table that is also called as dummy table dual is used to evaluate expressions example:select 3+4+6 from dual; or select sysdate from dual ...
what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
Latest Answer: SHARE UPDATE EXCLUSIVE This mode protects a table against concurrent schema changes and VACUUM runs. Acquired by VACUUM (without FULL), ANALYZE, and CREATE INDEX CONCURRENTLYEXCLUSIVE This mode allows only concurrent ACCESS SHARE locks, i.e., ...
Why IN query not worked in inner join?
Latest Answer: Inner Join is nothing but self join. In self join the system wil take one record from tabel (i.e. first objective) and compare with the same table but objective is different.so at a time your comparing one record of one table to another record of another ...
I have a very unusual question, how can one check which is the recent row added to a table?
Latest Answer: SCOPE_IDENTITY() would be a better option to get the most recently added row as the primary key for a table may not necessarily be an auto-incrementing variable. Therefore max(rowid) would not be the optimal solution in that case. ...
Can any one guide me how can i import and export schema using SQL and OEM
Latest Answer: In db2 three different format (ixf,del,asc) to export data:Export to tablename.ixf of ixf select * from tablename.
When do import we can define if the original data should be kept or cleaned. Insert will keep the data, replace will clean the original ...
I have a column in a table with names.Now i want to select that names like first name,second and third.I/p like this----- names Chandu Kannaka prasad
Latest Answer: select top 3 names from tablenameTry this u'll definately get the answer ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
