Recent questions tagged sql

0 votes
1 answer

What are Best Practices for preventing SQL injection in node-mysql?

Oct 21, 2024 in Web Development by Nidhi
 • 16,260 points • 1,523 views
0 votes
0 answers

Create a SQL enter script from an Excel worksheet

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

SQL: Find first occurrence of any character except the one specified

Apr 19, 2023 in Cyber Security & Ethical Hacking by anish
 • 400 points • 1,864 views
0 votes
1 answer

Excel VBA SQL Query on not saved Workbook

Apr 7, 2023 in Others by narikkadan
 • 86,360 points • 1,800 views
0 votes
0 answers

How to get the record count of all tables in athena aws?

Dec 13, 2022 in AWS by Ashwini
 • 5,440 points • 5,398 views
0 votes
1 answer

How to convert an excel formula to SQL to calculate daily compound interest

Nov 26, 2022 in Others by Kithuzzz
 • 38,000 points • 2,199 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 • 2,142 views
0 votes
0 answers

Should I choose Hiberlite for integrating SQLite into my Win/iOS application?

Nov 11, 2022 in Mobile Development by gaurav
 • 25,250 points • 1,301 views
0 votes
1 answer

Find max and second max salary for a employee table MySQL

Nov 4, 2022 in Others by gaurav
 • 25,250 points • 6,171 views
0 votes
1 answer

When doing a MERGE in Oracle SQL, how can I update rows that aren't matched in the SOURCE?

Nov 4, 2022 in Others by gaurav
 • 25,250 points • 2,885 views
0 votes
1 answer

How to get second-highest salary employees in a table

Nov 4, 2022 in Others by gaurav
 • 25,250 points • 3,027 views
0 votes
1 answer

Correct use of transactions in SQL Server

Nov 4, 2022 in Others by gaurav
 • 25,250 points • 1,562 views
0 votes
0 answers

SQL Query with NOT LIKE IN

Nov 4, 2022 in Others by gaurav
 • 25,250 points • 1,248 views
0 votes
1 answer

SQL query to select dates between two dates

Nov 4, 2022 in Others by gaurav
 • 25,250 points • 4,112 views
0 votes
1 answer

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

Nov 4, 2022 in Others by gaurav
 • 25,250 points • 2,149 views
0 votes
1 answer

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

Nov 4, 2022 in Others by gaurav
 • 25,250 points • 4,100 views
0 votes
1 answer

Is there a coalesce-like function in Excel?

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

Removing duplicates from Excel rows by adding values of some columns

Sep 22, 2022 in Others by Kithuzzz
 • 38,000 points • 2,066 views
0 votes
1 answer

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

Sep 19, 2022 in Database by Kithuzzz
 • 38,000 points • 11,850 views
0 votes
1 answer

How can I create a unique constraint on my column (SQL Server 2008 R2)?

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

Using ORDER BY and GROUP BY together

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

IN Clause with NULL or IS NULL

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

What is the difference between a primary key and a surrogate key?

Sep 19, 2022 in Database by Kithuzzz
 • 38,000 points • 10,877 views
0 votes
1 answer

How do I obtain a Query Execution Plan in SQL Server?

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

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

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

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

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

Function to Calculate Median in SQL Server

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

Highest Salary in each department

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

SQL Server: IF EXISTS ; ELSE

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

Best way to do nested case statement logic in SQL Server

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

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

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

How to find third or nᵗʰ maximum salary from salary table?

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

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

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

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

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

SQL like search string starts with

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

Not equal <> != operator on NULL

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

Oracle PL/SQL - ORA-01403 "No data found" when using "SELECT INTO"

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

SQL Server: Extract Table Meta-Data (description, fields and their data types)

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

How to print SQL statement in codeigniter model

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

Finding duplicate values in a SQL table

Sep 16, 2022 in Database by Kithuzzz
 • 38,000 points • 2,028 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 • 2,978 views
0 votes
1 answer

Getting only Month and Year from SQL DATE

Sep 16, 2022 in Database by Kithuzzz
 • 38,000 points • 3,923 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 • 8,457 views
0 votes
1 answer

CASE .. WHEN expression in Oracle SQL

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

SQL SELECT from multiple tables

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

SQL JOIN - WHERE clause vs. ON clause

Sep 14, 2022 in Database by Kithuzzz
 • 38,000 points • 2,864 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 • 2,432 views
0 votes
1 answer

Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?

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

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

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

Unpivot with column name

Sep 14, 2022 in Database by Kithuzzz
 • 38,000 points • 1,805 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.