Most answered questions under tag sql

+2 votes

1 answer

how to update table from select statement in sql server?

posted Jun 19, 2015 by Shivaranjini

+3 votes

1 answer

SQL update from one Table to another based on a ID match

posted Jun 19, 2015 by Manikandan J

+3 votes

1 answer

SQL Server - Update column from data in the same table

posted Jun 19, 2015 by Manikandan J

+3 votes

1 answer

Any body know the query about this senario

posted Jun 18, 2015 by Shivaranjini

+4 votes

1 answer

Please let me know the query to update this

posted Jun 18, 2015 by Shivaranjini

+1 vote

1 answer

Oracle: How does one add a day/hour/minute/second to a date value?

posted Jun 17, 2015 by Archana

0 votes

1 answer

Oracle: How can I get the time difference between two date columns?

posted Jun 17, 2015 by Archana

0 votes

1 answer

Oracle: How can I generate primary key values for my table?

posted Jun 17, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: How does one eliminate duplicates rows from a table with different methods?

posted Jun 17, 2015 by Vidhya Sagar

+2 votes

1 answer

Finding TOP X records from each group.

posted Jun 16, 2015 by Manikandan J

+1 vote

1 answer

SQL: Need help with Multiple Joins of Tables?

posted Jun 16, 2015 by Shivaranjini

+1 vote

1 answer

Help with Join operation in SQL

posted Jun 16, 2015 by Shivaranjini

+1 vote

1 answer

SQL: Get the highest number of each group and combine the result per parent column?

posted Jun 16, 2015 by Shivaranjini

+2 votes

1 answer

What is the default size of SQL Server Database

posted Jun 15, 2015 by Shivaranjini

+1 vote

1 answer

How to create a UNIQUE Key on a Column which is having multiple NULL values?

posted Jun 15, 2015 by Shivaranjini

+1 vote

1 answer

A table named fruit has the attributes "ID", "Fruit name" and "Basket No":

posted Jun 15, 2015 by Shivaranjini

+1 vote

1 answer

How to escape special characters when building SQL queries?

posted Jun 15, 2015 by Suchithra

0 votes

1 answer

Oracle: How display the names of employees who are working in the company for the past 5 years?

posted Jun 12, 2015 by Kunal Kapoor

+1 vote

1 answer

sql query of EMP table?

posted Jun 12, 2015 by Kunal Kapoor

+3 votes

1 answer

How to display the names of employees in Sql Query?

posted Jun 11, 2015 by Archana

+2 votes

1 answer

How to display names of employees who do not earn any commission in Oracle?

posted Jun 11, 2015 by Viswas Kumar

+2 votes

1 answer

How to display employee number and names for employees who earn commission in Oracle?

posted Jun 11, 2015 by Viswas Kumar

+2 votes

1 answer

How to display the names of all employees working as clerks and drawing a salary more than 3000?

posted Jun 9, 2015 by Vidhya Sagar

+1 vote

1 answer

How to display employee name and annual salary for all employees?

posted Jun 9, 2015 by Suchithra

+1 vote

1 answer

Display employee number and total salary for each employee in Oracle?

posted Jun 9, 2015 by Suchithra

+1 vote

1 answer

How to display name and salary for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+1 vote

1 answer

How to display the name and job for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+1 vote

1 answer

How to display the details of all employees in Oracle?

posted Jun 3, 2015 by Archana

+1 vote

1 answer

How to display the dept information from department table in Oracle?

posted Jun 3, 2015 by Archana

+2 votes

1 answer

Difference between SQL(RDBMS) and mongoDB ?

posted Jun 2, 2015 by Alok

+1 vote

1 answer

How you will avoid your query from using indexes in Oracle?

posted Jun 2, 2015 by Vidhya Sagar

+1 vote

1 answer

Which is more faster - IN or EXISTS In Oracle?

posted Jun 2, 2015 by Vidhya Sagar

+1 vote

1 answer

Find out nth highest salary from emp table in Oracle?

posted May 29, 2015 by Kunal Kapoor

+1 vote

1 answer

How does one code a matrix report in SQL using SUM & DECODE function?

posted May 29, 2015 by Kunal Kapoor

+1 vote

1 answer

How does one select EVERY Nth row from a table In Oracle?

posted May 28, 2015 by Viswas Kumar

+1 vote

1 answer

How does one select the TOP N rows from a table in Oracle?

posted May 28, 2015 by Viswas Kumar

+1 vote

1 answer

why Oracle’s procedural language is used for?

posted May 26, 2015 by Vidhya Sagar

+1 vote

1 answer

what is distributed database network?

posted May 26, 2015 by Vidhya Sagar

+2 votes

1 answer

Will non-procedural language specify what to do? or not how to do?

posted May 25, 2015 by Suchithra

+3 votes

1 answer

what is relations operator in Oracle?

posted May 25, 2015 by Suchithra

+1 vote

1 answer

which are the tools that allows direct and interactive use of the SQL language to access the Oracle server ?

posted May 22, 2015 by Kunal Kapoor

+1 vote

1 answer

SQL & Pl/SQL are used in which of the following products SQL*plus, Oracle Forms and Oracle reports?

posted May 22, 2015 by Kunal Kapoor

+2 votes

1 answer

Is SQL is Procedural language?

posted May 21, 2015 by Viswas Kumar

+2 votes

1 answer

what is the advantages of partitioning in Oracle?

posted May 20, 2015 by Archana

–1 vote

1 answer

what RDBMS stands for?

posted May 20, 2015 by Archana

+2 votes

1 answer

who found the principles of the relational model of database?

posted May 15, 2015 by Kunal Kapoor

+3 votes

1 answer

how to insert multiple records in a single query?

posted May 15, 2015 by Muskan

+1 vote

1 answer

How the relational database stores the data?

posted May 13, 2015 by Archana

+1 vote

1 answer

what is the minimum CODD rules for any DBMS to be considered as on RDBMS?

posted May 13, 2015 by Archana

+1 vote

1 answer

How to add Comments on table and columns in Oracle?

posted May 11, 2015 by Suchithra