Trending questions in Database

0 votes
0 answers

How to select the last record of a table in SQL?

Here is an example of code that ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
• 38,000 points
1,405 views
0 votes
1 answer

How do I change the menu language of Excel Online?

Click on App launcher from any worksheet ...READ MORE

Apr 1, 2022 in Database by gaurav
• 23,260 points
14,681 views
0 votes
0 answers

Insert multiple rows into single column

I am having problems adding numerous data ...READ MORE

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

Setting mime type for excel document

I assume application/vnd.ms-excel is the standard MIME ...READ MORE

Apr 4, 2022 in Database by gaurav
• 23,260 points
14,469 views
0 votes
0 answers

How to decrypt a password from SQL server?

Use the following SQL Server 2000 query: select ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
• 38,000 points
8,829 views
0 votes
1 answer

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

Option 1 is the only good solution. Why? Option ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,600 points
7,190 views
0 votes
1 answer

Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

This works quite well for SQL min/max dates ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,600 points
6,803 views
0 votes
1 answer

How to select from multiple tables without a JOIN ?

Try this: SELECT ... FROM ( SELECT ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,600 points
6,843 views
0 votes
1 answer

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

Just populate the field directly, using ordering ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
6,530 views
0 votes
1 answer

SQL Server Convert Varchar to Datetime

Try this: SELECT CONVERT(Datetime, '2011-09-28 18:01:00', 120) -- ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,600 points
6,704 views
0 votes
1 answer

Sigma or Summation function in Excel

The SUM function in Excel is another ...READ MORE

Mar 15, 2022 in Database by gaurav
• 23,260 points
14,556 views
0 votes
0 answers

Select employee details of dept number 10 or 30

Dept Table:                     DeptNo Dname Loc 10 Accounts Bangalore 20 IT Delhi 30 Production Chennai 40 Sales Hyd 50 Admn London Emp ...READ MORE

Feb 12, 2023 in Database by Nischitha

edited Mar 4 68 views
0 votes
1 answer

org.hibernate.exception.SQLGrammarException: could not extract ResultSet

In the stacktrace, there is a line ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,600 points
6,406 views
0 votes
1 answer

Use python extract images from Excel sheets

I found a solution # installing the modules pip3 ...READ MORE

Apr 11, 2022 in Database by gaurav
• 23,260 points
13,246 views
0 votes
1 answer

SQL Server Error : String or binary data would be truncated

You're trying to write more data than ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,600 points
6,363 views
0 votes
0 answers
0 votes
1 answer

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

If you need to delete based on ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,600 points
6,193 views
0 votes
1 answer

java.sql.SQLException: IO Exception : The Network adapter could not establish the connection?

As a result of our chat, you ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,600 points
6,311 views
0 votes
0 answers

CLEAR SCREEN - Oracle SQL Developer shortcut?

I was wondering if there was a ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
• 38,000 points
7,506 views
0 votes
0 answers

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

I experimented with the following code in ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,000 points
7,086 views
0 votes
1 answer

How to calculate percentage with a SQL statement

The following has passed my tests, and ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,600 points
6,244 views
0 votes
1 answer

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

First off, if you're starting a new ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,600 points
5,955 views
0 votes
1 answer

Convert Date format into DD/MMM/YYYY format in SQL Server

Using convert() and style 106, you can ...READ MORE

Feb 23, 2022 in Database by Vaani
• 7,070 points
14,659 views
0 votes
0 answers

java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Using OJDBC 6, I created some Java ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
• 38,000 points
7,143 views
0 votes
1 answer

Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?

 There were multiple issues. If you encounter ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,600 points
5,885 views
0 votes
1 answer

Laravel Excel import using Maatwebsite Excel package with additional columns from View

How to fix: I know you're fed ...READ MORE

Apr 1, 2022 in Database by gaurav
• 23,260 points
12,946 views
0 votes
1 answer

What's the difference between VARCHAR and CHAR?

CHAR is a fixed-length character data type, ...READ MORE

Apr 26, 2023 in Database by Kanav Chopra

edited Mar 5 915 views
0 votes
1 answer

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

I saw the problem in the line ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 63,600 points
5,666 views
0 votes
1 answer

How to print SQL statement in codeigniter model

To display the query string: print_r($this->db->last_query()); ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,600 points
5,227 views
0 votes
1 answer

Prevent cell numbers from incrementing in a formula in Excel

In Excel, you can use a feature ...READ MORE

Mar 15, 2022 in Database by gaurav
• 23,260 points
13,218 views
0 votes
1 answer

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

There is no LIKE & IN combination ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
5,017 views
0 votes
0 answers

How to display employee names starting with a and then b in sql

I want to display the names of ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
• 38,000 points
1,129 views
0 votes
0 answers

SQL Server Cannot perform an aggregate function on an expression containing an aggregate or a subquery

Error: Cannot perform an aggregate function on an ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
• 38,000 points
1,549 views
0 votes
0 answers

What is the difference between drop table and delete table in SQL Server?

What is the distinction between the following ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
• 38,000 points
1,060 views
0 votes
1 answer

how to Convert EST time to IST time in excel?

Use the following calculation since Indian Standard ...READ MORE

Mar 30, 2022 in Database by gaurav
• 23,260 points
12,127 views
0 votes
1 answer

Add Auto-Increment ID to existing table?

Make sure none of your other columns ...READ MORE

Feb 8, 2023 in Database by JPC

edited Mar 5 1,499 views
0 votes
0 answers

Get json object values and store as arrays

[ ['david','female','john','e6a33eee180b07e563d74fee8c2c66b8',1,1,'roger63'], ...READ MORE

Nov 16, 2022 in Database by Ashwini
• 5,430 points
1,752 views
0 votes
1 answer

SQL like search string starts with

SELECT * from games WHERE (lower(title) LIKE ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
4,331 views
0 votes
1 answer

Excel - how to calculate sum of multiple rows into different columns

The AutoSum button or formula can be ...READ MORE

Apr 4, 2022 in Database by Edureka
• 13,690 points
11,575 views
0 votes
1 answer

SQL Server: IF EXISTS ; ELSE

Try this: update b set code = ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
4,256 views
0 votes
1 answer

SQL - Update multiple records in one query

Try either multi-table update syntax: UPDATE config t1 ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,600 points
4,276 views
0 votes
1 answer

DB2 SQL error sqlcode=-104 sqlstate=42601

You missed the from clause: SELECT * from TCCAWZTXD.TCC_COIL_DEMODATA WHERE ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,600 points
4,445 views
0 votes
0 answers

How to get a particular date format ('dd-MMM-yyyy') in SELECT query SQL Server 2008 R2

To modify the format of a date ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
• 38,000 points
4,736 views
0 votes
0 answers

SQL Server FOR EACH Loop

SQL query: DECLARE @MyVar datetime = '1/1/2010' ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
• 38,000 points
5,130 views
0 votes
0 answers

SQL Server 2008 - IF NOT EXISTS INSERT ELSE UPDATE

I'm trying to create a time clock ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
• 38,000 points
4,655 views
0 votes
0 answers

why this error ? ERROR Cannot add or update a child row a foreign key constraint fails

create table per( sl_no int UNIQUE NOT ...READ MORE

Dec 13, 2022 in Database by abc

edited Mar 4 61 views
0 votes
1 answer

java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

The maximum-open-cursors error, also known as ORA-01000, ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 63,600 points

edited Jul 5, 2023 by Khan Sarfaraz 4,050 views
0 votes
1 answer

How to open a password protected excel file using python?

I recently came upon a Python package ...READ MORE

Apr 6, 2022 in Database by gaurav
• 23,260 points
10,681 views
0 votes
1 answer

Excel Reference To Current Cell

Create a formula with the name THIS ...READ MORE

Mar 25, 2022 in Database by gaurav
• 23,260 points
11,237 views
0 votes
1 answer

How to retrieve data from sqlite database in android and display it in TextView

When a button is clicked, the database ...READ MORE

Aug 11, 2022 in Database by narikkadan
• 63,600 points

edited Mar 5 5,192 views