Recent questions tagged sql

0 votes
1 answer

Removing duplicates from Excel rows by adding values of some columns

Sep 22 in Others by Kithuzzz
 • 12,440 points • 18 views
0 votes
1 answer

ERROR 1064 (42000): You have an error in your SQL syntax;

Sep 19 in Database by Kithuzzz
 • 12,440 points • 210 views
0 votes
1 answer

Using ORDER BY and GROUP BY together

Sep 19 in Database by Kithuzzz
 • 12,440 points • 22 views
0 votes
1 answer

How do I do multiple CASE WHEN conditions using SQL Server 2008?

Sep 19 in Database by Kithuzzz
 • 12,440 points • 18 views
0 votes
1 answer

Function to Calculate Median in SQL Server

Sep 18 in Database by Kithuzzz
 • 12,440 points • 32 views
0 votes
1 answer

Highest Salary in each department

Sep 18 in Database by Kithuzzz
 • 12,440 points • 25 views
0 votes
1 answer

SQL Server: IF EXISTS ; ELSE

Sep 18 in Database by Kithuzzz
 • 12,440 points • 29 views
0 votes
1 answer

What does SELECT COUNT(1) from table_name on any database table mean

Sep 18 in Database by Kithuzzz
 • 12,440 points • 19 views
0 votes
1 answer

Is there a combination of "LIKE" and "IN" in SQL?

Sep 17 in Database by Kithuzzz
 • 12,440 points • 22 views
0 votes
1 answer

How to find top three highest salary in emp table in oracle?

Sep 17 in Database by Kithuzzz
 • 12,440 points • 68 views
0 votes
1 answer

SQL like search string starts with

Sep 17 in Database by Kithuzzz
 • 12,440 points • 28 views
0 votes
1 answer

Not equal <> != operator on NULL

Sep 17 in Database by Kithuzzz
 • 12,440 points • 17 views
0 votes
1 answer

How to print SQL statement in codeigniter model

Sep 16 in Database by Kithuzzz
 • 12,440 points • 17 views
0 votes
1 answer

Finding duplicate values in a SQL table

Sep 16 in Database by Kithuzzz
 • 12,440 points • 14 views
0 votes
1 answer

What is the equivalent of 'describe table' in SQL Server?

Sep 16 in Database by Kithuzzz
 • 12,440 points • 19 views
0 votes
1 answer

Getting only Month and Year from SQL DATE

Sep 16 in Database by Kithuzzz
 • 12,440 points • 31 views
0 votes
1 answer

How to delete multiple rows in SQL where id = (x to y)

Sep 16 in Database by Kithuzzz
 • 12,440 points • 42 views
0 votes
1 answer

CASE .. WHEN expression in Oracle SQL

Sep 16 in Database by Kithuzzz
 • 12,440 points • 13 views
0 votes
1 answer

SQL SELECT from multiple tables

Sep 14 in Database by Kithuzzz
 • 12,440 points • 26 views
0 votes
1 answer

SQL JOIN - WHERE clause vs. ON clause

Sep 14 in Database by Kithuzzz
 • 12,440 points • 28 views
0 votes
1 answer

How to add a Try/Catch to SQL Stored Procedure

Sep 14 in Database by Kithuzzz
 • 12,440 points • 25 views
0 votes
1 answer

SQL query - Dept and Employee table, some departments may not have managers

Sep 14 in Database by Kithuzzz
 • 12,440 points • 47 views
0 votes
1 answer

Unpivot with column name

Sep 14 in Database by Kithuzzz
 • 12,440 points • 19 views
0 votes
1 answer

SQL Inner-join with 3 tables?

Sep 13 in Database by Kithuzzz
 • 12,440 points • 36 views
0 votes
1 answer

How do I perform the SQL Join equivalent in MongoDB?

Sep 13 in Database by Kithuzzz
 • 12,440 points • 38 views
0 votes
1 answer

LIMIT 10..20 in SQL Server

Sep 13 in Database by Kithuzzz
 • 12,440 points • 32 views
0 votes
1 answer

SQL Error: ORA-00922: missing or invalid option

Sep 13 in Database by Kithuzzz
 • 12,440 points • 79 views
0 votes
1 answer

Create enum in SQL Server

Sep 13 in Database by Kithuzzz
 • 12,440 points • 69 views
0 votes
1 answer

SQL Error: ORA-01861: literal does not match format string 01861

Sep 12 in Database by Kithuzzz
 • 12,440 points • 88 views
0 votes
1 answer

SQL Server Convert Varchar to Datetime

Sep 12 in Database by Kithuzzz
 • 12,440 points • 130 views
0 votes
0 answers

Query comparing dates in SQL

Sep 12 in Database by Kithuzzz
 • 12,440 points • 38 views
0 votes
1 answer

How can I confirm a database is Oracle & what version it is using SQL?

Sep 11 in Database by Kithuzzz
 • 12,440 points • 33 views
0 votes
1 answer

What's the difference between VARCHAR and CHAR?

Sep 11 in Database by Kithuzzz
 • 12,440 points • 21 views
0 votes
1 answer

SQL WHERE ID IN (id1, id2, ..., idn)

Sep 11 in Database by Kithuzzz
 • 12,440 points • 44 views
0 votes
1 answer

DB2 SQL error sqlcode=-104 sqlstate=42601

Sep 11 in Database by Kithuzzz
 • 12,440 points • 69 views
0 votes
0 answers

How to calculate percentage with a SQL statement

Sep 10 in Database by Kithuzzz
 • 12,440 points • 15 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.