PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
- 6 Answers
- 15154 Views
- APX, I also Faced
- E-Mail Answers
Answer Posted / guest
Select * from PC
group by hd
having count(*)>1
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
How do I create a trace in sql server?
What are the different SQL Server Versions you have worked on?
Why and when do stored procedure recompile?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What are the different types of subquery?
Explain “row_number()” in sql server with an example?
What is a view in sql?
Does view occupy space?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Why we use the openxml clause?
What is the primary use of the model database?
When should you use an instead of trigger?
What are the properties of the transaction?
What are the different subsets of sql?
What kind of problems occurs if we do not implement proper locking strategy?
