If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?
9 13447
What is mysql community edition?
What are internal user account in oracle?
what are the advantages of sql ? : Sql dba
explain the advantages and disadvantages of stored procedure? : Sql dba
What are the differences between a primary key and foreign key?
Is full outer join same as cross join?
What is the difference between a primary key and a composite key?
How do you delete duplicate records in sql server?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
What is character varying in postgres?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a
What is the difference between mongodb and mysql?