• Register

Recent questions tagged sql

0 votes
1 answer 2 views
0 votes
1 answer 4 views
0 votes
1 answer 3 views
0 votes
1 answer 2 views
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
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
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
asked 3 days ago SapperIt 1.2k points
0 votes
1 answer 6 views
0 votes
1 answer 7 views
0 votes
1 answer 5 views
asked 3 days ago SapperIt 1.2k points
0 votes
1 answer 8 views
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
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
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
0 votes
1 answer 5 views
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
0 votes
1 answer 6 views
asked 4 days ago SapperIt 1.2k points
0 votes
1 answer 11 views
0 votes
1 answer 3 views
What is the difference between unique and distinct in SQL?
asked Oct 11 sikandar 2.4k points