menu
  • Register

Recent questions tagged sql

0 votes
1 answer 2 views
What is the difference between SQL server 2012 and 2014
asked 23 hours ago miki 770 points
0 votes
1 answer 4 views
How to drop all tables in SQL
asked 1 day ago miki 770 points
0 votes
1 answer 3 views
How to connect HTML to SQL database
asked 1 day ago miki 770 points
0 votes
1 answer 2 views
difference between stored procedure and function in sql server
I always used SP in Sql, today I wrote my first UDF. I wonder what a difference? Are Sql functions identical to programming language functions?
asked 1 day ago alexh 430 points
0 votes
1 answer 5 views
How to delete a column from a table in sql?
Problem: I have created a table with two columns and now I want to delete one column from my table. Is there any mechanism to do so? If yes, then how can I do that?
asked 2 days ago Sheeza 2.4k points
0 votes
1 answer 4 views
Delete without Where clause
Problem: I want to know what happens if I use delete command without WHERE clause? Does it make any difference if I skip the WHERE clause?
asked 2 days ago Sheeza 2.4k points
0 votes
1 answer 4 views
How to find nth salary in SQL
asked 3 days ago SapperIt 1.2k points
0 votes
1 answer 6 views
How to select from multiple tables in sql
asked 3 days ago SapperIt 1.2k points
0 votes
1 answer 7 views
How to find second highest salary in sql
asked 3 days ago SapperIt 1.2k points
0 votes
1 answer 5 views
How to execute a function in sql
asked 3 days ago SapperIt 1.2k points
0 votes
1 answer 8 views
sql ddl dml dcl tcl commands with examples
Problem: What is ddl, dml, dcl and tcl commands? Please explain with examples.
asked 3 days ago Sheeza 2.4k points
0 votes
1 answer 4 views
How to Add two columns in SQL?
Problem: I am new to the world of SQL, and currently I am working with marks of students. I want to obtain the total marks in a column by adding all the subject marks of students. I do not know whether there is a way to do this in SQL or not. If there is a way, please mention and elaborate, if not, then please guide how it can be done. Thanks
asked 3 days ago Sheeza 2.4k points
0 votes
1 answer 4 views
name of employee with maximum salary.
Problem: I want to see the name of the employee with highest salary in our company. How can this be done? Also, how can I find the employee with 2nd highest salary?
asked 4 days ago Sheeza 2.4k points
0 votes
1 answer 6 views
Are table variable and temp table the same in SQL?
asked 4 days ago miki 770 points
0 votes
1 answer 5 views
SQL query all columns (attributes) for every row in the city table.
Problem: I have a City table and I want to query all the cities of Pakistan that have the population larger than 200000 and their names start in H. Country code for Pakistan is Pak. How can I do that using SQL?
asked 4 days ago Sheeza 2.4k points
0 votes
1 answer 7 views
Selecting tables containing a column name
asked 4 days ago miki 770 points
0 votes
1 answer 6 views
Select * from table where id =
asked 4 days ago SapperIt 1.2k points
0 votes
1 answer 11 views
SQL Server: how to create a table if not exists
asked Oct 13 miki 770 points
0 votes
1 answer 3 views
Difference between unique and distinct in sql
What is the difference between unique and distinct in SQL?
asked Oct 11 sikandar 2.4k points
Page:
Dark theme