- Find duplicate entries in a table?
- Insert or update a record if it already exists?
- Calculate the median value of a column?
- When is a view updatable in SQL-99?
- Select a row at random?
- Which ER design tools do you use?
- Find the minimum or maximum value across several columns?
- How can I selet rows which have 2 columns values cross equal?
- How can I store and retrieve a tif file?
- Find the maximum value of a column and return the corresponding id?
- Return a comma seperated string?
- How to order rows in a predefined pattern?
- Find Your Most-Commented Blog Categories in Wordpress?
- count how many nights each room of an hotel had been rent for a complete year?
- List all customers from table customers that haven't made any order during year 2005?
- List by ascending number of orders the customers that have placed more than 1 order?
- List all customers who ordered products where price of the item is $100 greater than average order?
- List players by numbers of points?
- List all customers whose name is present more than once in the table?
- Insert data from tableA into TableB if idA is not already in tableB?
- Create a third row that make the sum of past row + current row (i.e. a running sum)?
- List all results except the biggest?
- List from particular customers with minum orders?
- list customers with average ordered quantities?
- How to impose a check that a certain field can only contain a certain domain of values?
- How do I ensure that a field in a table must contain values within a specific range?
- How do i perform an If statement on a cloumn?
- How do I insert multiple new records from a web form field into an MS Access database?
- How can I shrink all text columns in a table?
- How can I perform a table wide replace statememt?
- How do I avoid chicken and egg problems?
- Query a table using data in another table?
- How to declare Composite Keys?
- How to pull data from several tables that follows a pattern?
- Do two joins in a single query?
- How to use BASE36 conversion in Oracle / SQL?
- how to swap row and columns in oracle?
- How do i select the most rented movie in a movierentals table in access?
- displaying a group by and grand total all on one line?
- difficult pivot?
- How to retrieve records which the date column should be 36 months older than the current date?
- How to find second highest value of a column in a table?
- what is stored procedure? tell me in detail.?
- want to see all the queries for sql?
- How the REF in Object Relational SQL works?
- how can i select the third row from table?
- get the value of the 3rd row from bottom?
- what is sql data import and data export utility?
- How to find second highest value of a column in a table? | SQL?
- How do I find out which columns are foreign keys in a table?
- How do I select the highest 20 to 30 values?
- query containing entries that begin with same 3 letters as at least one other entry?
- How do I implement LastIndexOf functionality in SQLServer 2000?
- Write a SQL statement to change the name of a record?
- Does Not Exist?
- How do I batch check 30 fields for NULL?
- How do i create a query to extract all records within a given date. For instance beginning date and?
- how to find third highest record from table?
- in which language the SQL is implemented..c, c++, etc..?
- Selecting Duplicate Entries in a table?
- Maximum Value - Beginner Question?
- Updating 2 rows with just 1 row of data?
- to convert rows to column using SQL?
- How can I find fields that have a substring in common?
- SQL Joins?
- How to form Query for details given?
- maximun number of columns define in sql server data table?
- How to use two joins in a single query?
- HOW DO I SELECT FROM MULTIPLE FIELDS USING QUERY?
- How can you find all tables for a particular value?
- How to perform aggregation (sum) on a computed column?
- selecting a record based on a persons name?
- How to query for valid email address with _@_._ format?
- How to select highest value and then create new object with that value +1?
- How do I sort results using ORDER BY?
- i want to get the third highest salary from a table?
- Trim statement?
- How do i compare NUMBER to VARCHAR?
- compare?
- How do I format mySQL date?
- How to union two tables, and make one "override" the other for similar records?
- How can I select a Field and then add that field as a column?
- How do I make one field be a function of another?
- What's the best source of Country/City/Region names for a db?
- Max stringlength from several tables?
- Count entries per month?
- Find matches with no repeats?
- How to get table structure via SQL?
- Find matching names on similar streets?
- can i wrire a query which sum up more than 2 columns in a single table?
- Find empty columns?
- Simple templates by user listing?
- Select the 4 row of the table from the top?
- how to write select query for merging two columns?
- how to find out the 4th highest value from the column?
- How can I store Images(*.jpg,*.gif)?
- select the candidate who have atleast two subjects to appear in exam.?
- how to select the last four rows from a table?
- how can we assign rank to the in the result?
- I am using ms access and require the merging of info to a column; currently the column has values?
- how to find nth salary?
- convert the integer value to string?
- The top x most popular whatever?
- to find top 10 salaries of employees with their names
- create one script that will combine multiple statements
- Select Min how to
- update table
- How to change 100minutes to 00:00:00 format
- I need to see the tables
- Data Types
- delete from table where column != (multiple values)
- Invoice/Bill from retail Database in Report Format
- Oracle Conversion
- Select the rows with the same value
- Dates in Access 2007
- How to find distinct users based on last logon
- ON or WHERE: which one is the fastest?
- Use varipus select Statement in 1 update
- Table within a Table
- How to use the Ref Commad?
- How do I update a field in one table with the value of a select call on another table
- How to know column typ
- how to find parent & child related records
- SQL: max value from a column?
- How to COUNT records in UNION?
- Most Basic SQL Question
- ORA-01000: maximum open cursors exceeded
- subselect to inner join
- How to find suppliers that sell all product or more than 1 product ?
- Write a Command to Find Blank Cells...
- SQL for Comparing values
- query to display only the distinct data and not the identical ones
- Top 3rd value
- A few query questions
- write top 5 qurey
- Display from tables
- Extracting(Display) the data from tables in Certain Conditions(Please help me)
- how to insert data into 2 tables by using one query
- Trying to Get this Code to work
- How can I sum values by week
- Incorporated vendors products less than $150
- how to see the applied constraints of the table
- seeing constraints applied on a table
- Multiple translations of ID Field
- Either initialization or shutting down in progress
- Best practice to normalize many common relationships
- Find maximum value between 2 columns of different table
- Pivoting without aggregating - is this possible?
- how many ways to using the Update command
- Using order by inside subquery
- rownum in 9i
- Sql Tables For Practice
- comparing tables in access using sql....
- how to see the text given for example create command in the sql prompt?
- how do we delete redundant entries from a table ?
- How to retrive data from a column which contains both date and time
- Stuck with a query question
- How to find if categories are set for employees
- Plz give solution 4 this query
- How to find the Grandparent of this data
- I Need Redesign An Existing Website Which Contains PHP, SQL & Html. HOW?
- Sqlj
- Left-OuterJoin selecting only the first of 0-to-2 matching rows on the right
- Leap year and not a leap year
- cursor based thread
- pl/sql block
- to find n'th largest or smalest value in a table
- urgent, does any1 knoiw
- Sql cook book code download link?
- Combining Queries
- how to display different names pronounced with similar sound in a colomn for a table?
- generate shopping list based on the selected recipe
- creating table where 3rd column should be sum of first two columns
- please answer my question from correlated queries
- How to number rows in Oracle
- query
- loading gridview on textchanged event
- How turn text to SQL --> Select * ' From Emp'
- number to date
- lemme know
- Select records that are expiring in a month
- i need the query
- i need the query
- SP to alter all tables in db whos datatype is FLOAT
- String manipulation
- Checking whether values in one table are missing from grouping in 2nd table
- how do find the 15th highest value in the coloum without using subquery?
- Database schema versioning tool?
- Getting Data From Excel
- Accessing data In reverse Order
- Schema Compare using information Schema Views
- Select Query with different fields
- dropping a column from table
- finding differences within the same group of records
- 3 table merge?
- I Need Query urgent
- Table Matching with subquery
- constraint with if-then
- SQL Query for finding the data weekwise
- Text manipulation
- I need help w/ a query - URGENT
- Leap year
- Newly uploaded photos
- odd/even record display
- odd/even record display
- Stock holdings
- Dublicate Rows
- Query SQL -- help !!!
- Systems Engineer
- Regd Query
- SQL Server
- conversion from 9digit to 8digit number:urgent
- Querying the Database
- Show Distinct Values Along With Count
- How at a specified time can a database update itself with other database
- "Condition table" query
- sql queries for RCA .... pls help us
- Sql Scripts
- Using SQL Query, find minimun price of each brand.?
- Selecting multiple occurence on a table
- Want to return three columns for a maximum value
- how to write
- Another question: Find the minimum value across several columns for each row?
- finding groups of related data
- multiple enteries for one id number
- vertical rows in horizantal
- Row Number Each Group
- Complicated sorting in one sql
- select the most commonly repeated value from the table
- select values from the 2 different table
- How to select a record based on 1 field being min/max
- Find results with repeats
- Arithmetic overflow error converting expression to data type int.
- How to Find a CLIENT is getting service Between Two dates
- Which Plan is the most efficient one?
- how to find the eigth highest value from a column
- explanation of the query
- Need to eliminate dupes sharing first 10 digits
- error returned for a query containg case
- nested queries
- Delete Multiple Items in Multiple table
- to add constraint to an attribute
- Help needed for sql query : Procedure & Insert trigger
- crosstab query in sql
- trigger does not work for some values
- How do I concatenate values in the same column
- Rows to String
- how to generate numbers automatically from 1-100 without using sequence and connectby
- =MIN(A1:B2) need to know how to do this in access 2000
- Help required on a SQL Query