keys 相关的搜索结果 共有8个

Top N Clients Accounting for Half of the Total Sales in a Certain Year

l  Problem The table below is the historic sales contracts of an enterprise: The table below is the Client table: Among group,descendingorder,file,import,keys,switch,pselect

Count the Married Couples Whose Total Age is Over 70 Inclusive

l  Problem An enterprise is planning to allocate the welfare houses with low price to its married couple employees,who areplace,table sequence,file,import,keys,switch,new,select

Employees Who Have Worked in New York for over 5 Years Cumulatively

l  Problem The table below is an employee info list of a company. Employees in the company transfer regularly due to busgroup,table sequence,loop,file,import,keys,switch,new,sum,for

Commodities with the Longest Accumulated Out-of-Stock Time in a Month

l  Problem The tables below are from a simplified supermarket stock control system. To check if the purchase policy is pcreate a sequence,loop,file,import,periods,align,keys,for

Average Residence Time of Certain Types of Commodities in the Supermarket before Being Sold Out

l  Problem The tables below are some tables from simplified supermarket stock control system. To investigate the sales saverage,conversion,file,import,keys,switch,sum,long,floor

Customers who Ordered All Types of Products

l  Problem There are some database tables on the order status as given below. The Customers table which records customermaterialize the association,update,file,import,keys,switch,avg

Employees Who Have Taken a Leave Longer Than 2 Consecutive Days Three Times in a Year

l  Problem The LeaveRecords table is used to record the leaves of employees in 2009, including the start date and end dacoordinate translation of the sequence,tablesequence,group,file,import,group,keys,find

In-memory tables

An entity table can be imported into the memory to become an in-memory table, which is used like a normal table sequencein-memory table,memory,len,keys,row,find,index