Recent questions tagged sql

0 votes
0 answers

Create a SQL enter script from an Excel worksheet

Sep 8, 2023 in Database by Satyawrat
• 460 points
570 views
0 votes
1 answer

Excel VBA SQL Query on not saved Workbook

Apr 7, 2023 in Others by narikkadan
• 63,600 points
651 views
0 votes
1 answer

How to download SQL data in excel format using asp.net

Nov 14, 2022 in Others by Kithuzzz
• 38,000 points
1,090 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Correct use of transactions in SQL Server

Nov 4, 2022 in Others by gaurav
• 23,260 points
592 views
0 votes
0 answers

SQL Query with NOT LIKE IN

Nov 4, 2022 in Others by gaurav
• 23,260 points
450 views
0 votes
1 answer
0 votes
1 answer

How to use count and group by at the same select statement

Nov 4, 2022 in Others by gaurav
• 23,260 points
896 views
0 votes
1 answer

SQL Error: ORA-00933: SQL command not properly ended

Nov 4, 2022 in Others by gaurav
• 23,260 points
1,132 views
0 votes
1 answer

Is there a coalesce-like function in Excel?

Oct 20, 2022 in Others by Kithuzzz
• 38,000 points
3,949 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Function to Calculate Median in SQL Server

Sep 18, 2022 in Database by Kithuzzz
• 38,000 points
1,502 views
0 votes
1 answer

Highest Salary in each department

Sep 18, 2022 in Database by Kithuzzz
• 38,000 points
2,247 views
0 votes
1 answer

SQL Server: IF EXISTS ; ELSE

Sep 18, 2022 in Database by Kithuzzz
• 38,000 points
3,937 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

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

Sep 17, 2022 in Database by Kithuzzz
• 38,000 points
4,603 views
0 votes
1 answer
0 votes
1 answer

SQL like search string starts with

Sep 17, 2022 in Database by Kithuzzz
• 38,000 points
4,151 views
0 votes
1 answer

Not equal <> != operator on NULL

Sep 17, 2022 in Database by Kithuzzz
• 38,000 points
893 views
0 votes
1 answer
0 votes
1 answer

How to print SQL statement in codeigniter model

Sep 16, 2022 in Database by Kithuzzz
• 38,000 points
4,710 views
0 votes
1 answer

Finding duplicate values in a SQL table

Sep 16, 2022 in Database by Kithuzzz
• 38,000 points
933 views
0 votes
1 answer

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

Sep 16, 2022 in Database by Kithuzzz
• 38,000 points
1,023 views
0 votes
1 answer

Getting only Month and Year from SQL DATE

Sep 16, 2022 in Database by Kithuzzz
• 38,000 points
1,970 views
0 votes
1 answer

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

Sep 16, 2022 in Database by Kithuzzz
• 38,000 points
5,811 views
0 votes
1 answer

CASE .. WHEN expression in Oracle SQL

Sep 16, 2022 in Database by Kithuzzz
• 38,000 points
649 views
0 votes
1 answer

SQL SELECT from multiple tables

Sep 14, 2022 in Database by Kithuzzz
• 38,000 points
646 views
0 votes
1 answer

SQL JOIN - WHERE clause vs. ON clause

Sep 14, 2022 in Database by Kithuzzz
• 38,000 points
1,188 views
0 votes
1 answer

How to add a Try/Catch to SQL Stored Procedure

Sep 14, 2022 in Database by Kithuzzz
• 38,000 points
1,194 views
0 votes
1 answer
0 votes
1 answer

Unpivot with column name

Sep 14, 2022 in Database by Kithuzzz
• 38,000 points
787 views