db2 sql interview questions

Tags: des http io using AR for data problem sp Description: Create a database Create DATABASE Database-name Description: Deleting a database Drop database dbname Macau Venetian Casino Description: Backing up SQL Server To create a device that backs up dataUse masterexec sp_addumpdevice ' disk ', ' testback ', ' C:\mssql7backup\MyNwind_1.dat 'Start BackupBACKUP DATABASE pubs to Testback Description: Cr

When we get the title, is not eager to answer, that will outweigh the gains, but the analysis of ideas, what method to achieve what purpose, but also have to think of a simple method or general methods, etc., so as to achieve the effect of Isidam, such inertia thinking in fact, early in our high school when it was learned, The so-called "Same" bar. The following topics come from everyday see, or QQ group, or interview

Server| Solutions | questions Q. What are the main versions of the SQL Server 2005 product line? A. The SQL Server 2005 product family is redesigned to better meet the needs of different customers, and it includes the following versions: SQL Server 2005 Enterprise Edition is a platform for fully integrated da

SQL interview test (Part 1), sqlpart This article is inOn the basis of the original Cat Qi post, the notes implemented by myself in the MySql database by question are continuously updated... Refer to the original post:Http://www.cnblogs.com/qixuejia/p/3637735.html 01 table structure Student (Sno, Sname, Sage, Ssex) Student tableCourse (Cno, Cname, Tno) CurriculumSC (Sno, Cno, score) Orders tableTeacher (Tno

Server| problem is difficult to find a very qualified database developer in the workplace. One of my colleagues once said: "SQL Development is a language, it is easy to learn, but difficult to grasp." ” When interviewing a candidate for a SQL Server Database developer, I used a standard set of benchmark technical issues. Here are a few of the questions I think ca

amount of the month, Debitoccur: The amount of the occurrence.Database name: Jcyaudit, Data set: Select * from TestDBAnswer: Select A.*From TestDB A, (select Occmonth,max (debitoccur) debit101ccur from TestDB where accid= ' 101 ' GROUP by Occmonth) bwhere A.occmonth=b.occmonth and A.debitoccur>b.debit101ccur************************************************************************************Interview question: How to put such a tableYear Month amount1

1. An SQL statement interview question about groupTable content:VictoryVictoryNegativeNegativeVictoryNegativeNegative How do I write an SQL statement to generate the following results? Win-win2 21 2------------------------------------------Create Table # TMP (RQ varchar (10), shengfu nchar (1 )) Insert into # TMP values ('2017-2005 ', 'sheng ')Insert into # TM

, count (col001) A1 from temp1 where col002 = 'sheng' group by col001),(Select col001, count (col001) B1 from temp1 where col002 = 'negative 'group by col001) BWhere a. col001 = B. col001 2. Ask an SQL statement query question during the interview.The table has three columns a B c, which are implemented using SQL statements: When Column A is greater than Column B, select column A; otherwise, select Column

Tags: SQL ServerWhen we get the topic, is not eager to answer, that will not be worth the candle, but the analysis of ideas, the use of what method, to achieve what purpose, but also to consider whether there is a simple method or a common method and so on, so that it will achieve inordinately effect, such inertia thinking in our high school when the time was learned, The so-called "original Aim" bar. The following topics are from the daily view, or Q

Tags: SQL face questionswhen we get the topic, is not eager to answer, that will be worth the candle, but the analysis of ideas, the use of what method, to achieve what purpose, but also to consider whether there is no simple method or universal method, etc., so that it will achieve inordinately effect, Such inertia thinking in fact, as early as our high school when it was tasted, so-called "original Aim" bar. The following topics are from the daily v

where shengfu= ' negative ' GROUP by RQ) M on N.RQ=M.RQ3) Select A.col001,a.a1 wins, B.b1 negative from(select Col001,count (col001) A1 from Temp1 where col002= ' wins ' GROUP by col001) A,(select Col001,count (col001) B1 from Temp1 where col002= ' negative ' GROUP by col001) bwhere a.col001=b.col0012. Ask a query question for an SQL statement encountered during an interviewThe table has a B C three column, implemented with the