menu
  • Register

Want to solve programming problems and get paid for it? If that sounds interesting to you then contact us.

Recent questions tagged sql

Recent questions tagged sql

0 votes
1 answer 6 views
SQL: Which of the following commands is used to issue a query?
Problem: Hi there! I want to know which command is used to retrieve data from a database in SQL? How do we use it and when to use it? I am a beginner so I am looking for a detailed answer. Thanks!
asked 1 day ago Code Learner 5.5k points
0 votes
1 answer 13 views
SQL: You use aggregate functions to perform calculations based on groups of records
Problem: Hello! I am learning SQL. I came across the following statement while attempting a self-assessment quiz: You use aggregate functions to perform calculations based on groups of records (True/False) I do not know Aggregate functions so I skipped this question. Can someone from here please explain what the above statement means? Moreover, please explain the aggregated functions. Thanks!
asked 4 days ago Code Learner 5.5k points
0 votes
1 answer 3 views
SQL: Which of the following terms refers to commands that are used to create or modify database tables?
Problem: Hi there! I am learning SQL. Somewhere I saw a multiple choice question in which a list of terms was given and I had to choose the terms that refer to the commands used to create or modify database tables and columns. Following is the list of keywords: ... of most of these commands. I have learned only basics yet. If someone could explain all these commands, I would be grateful. Thanks!
asked 5 days ago Code Learner 5.5k points
0 votes
1 answer 2 views
SQL delete duplicate rows but keep original
Problem Hey, I have a problem, my emails are getting duplicated, I have a unique id and email. I just want to keep all my duplicates with the latest id.can you please help to find the answer.answer?
asked Jan 5 chris jordan 2.2k points
0 votes
1 answer 7 views
java.sql.sqlexception: no suitable driver found for
Solve this problem.
asked Jan 3 TeamScript 9.9k points
0 votes
1 answer 5 views
could not continue scan with nolock due to data movement
asked Dec 30, 2020 miki 1.9k points
0 votes
2 answers 5 views
saving changes is not permitted sql server
asked Dec 30, 2020 miki 1.9k points
0 votes
1 answer 7 views
Difference between inner join and natural join
Problem: What are JOINS in Sql and What is difference between inner join and natural join?
asked Dec 21, 2020 prog_learner 2.5k points
0 votes
1 answer 7 views
Difference between primary key and unique key and foreign key
Problem: Can anyone explain: What is the difference between primary key and unique key and foreign key?
asked Dec 21, 2020 prog_learner 2.5k points
0 votes
1 answer 9 views
Difference between stored procedure and trigger
Problem: What is Stored procedure and trigger, and the difference between stored procedure and trigger.
asked Dec 19, 2020 prog_learner 2.5k points
0 votes
1 answer 8 views
How to find second highest salary in sql using rank() function?
Problem I am working on some query for my project and the requirement is to show the second value. For sake of example, say I have salary table in Microsoft SQL Server and I need fetch the second maximum salary. I am not too experienced in T-SQL, I used the ... So I sow there is RANK() function in T-SQL, but I do not completely understand how it works. Any suggestions will very appreciated.
asked Dec 17, 2020 alexh 2.2k points
0 votes
1 answer 6 views
Difference between delete and truncate in sql
Problem I had not been used SQL a lot at my last position, the company had dedicated SQL Server DBA, but now I have changed the position and I deal with data bases in general and SQL Server in particular a lot. I am a bit confused by a difference between truncate, delete and drop. All the three removes data, but what is the difference?
asked Dec 10, 2020 alexh 2.2k points
0 votes
1 answer 12 views
Convert Julian date to calendar date in SQL
Convert Julian date to calendar date in SQL I have searched but I can't seem to find a way to convert Julian to yyyy-mm-dd.
asked Dec 3, 2020 miki 1.9k points
0 votes
1 answer 12 views
String or binary data would be truncated SQL Server
String or binary data would be truncated SQL Server When I tried to add data to a newly created column using SQL Server Management Studio, I got the error above. I need help to solve the problem.
asked Dec 1, 2020 miki 1.9k points
0 votes
1 answer 4 views
The login is from an untrusted domain and cannot be used with Windows authentication.
The login is from an untrusted domain and cannot be used with Windows authentication. Whenever I try to connect to a SQL server database, I get this error. Can you give me some advice?
asked Dec 1, 2020 miki 1.9k points
0 votes
1 answer 13 views
Java SQL sqlexception no suitable driver found
I can not access my database in MySQL. Any idea?
asked Nov 28, 2020 miki 1.9k points
0 votes
1 answer 10 views
This is incompatible with sql_mode=only_full_group_by
This is incompatible with sql_mode=only_full_group_by I installed a new version of SQL, and I received this error message. How can I fix it?
asked Nov 27, 2020 miki 1.9k points
0 votes
1 answer 16 views
SQL check if record exists before insert
SQL check if record exists before insert I need to write a stored procedure to update a row. If the row does not exist, I need to insert it. Any Idea?
asked Nov 26, 2020 miki 1.9k points
0 votes
1 answer 26 views
String or binary data would be truncated in SQL
String or binary data would be truncated in SQL I have the error when I am inserting a row in SQL. Any idea?
asked Nov 25, 2020 miki 1.9k points
0 votes
1 answer 5 views
SQL query between two dates and times
SQL query between two dates and times I need to select the records between two specific dates and times. Any idea?
asked Nov 25, 2020 miki 1.9k points
Page:
Dark theme