write sql program to get the detail of student in a class?
- 2 Answers
- 9389 Views
- I also Faced
- E-Mail Answers
Answer Posted / muruga nandhini.p
create table student
(
roll_no int,
name varchar(20),
class int,
address varchar(50),
phone int
)
++++++++++++++++run select than press f5
insert into student values(1,'Bhagwat',10,'Mathura',9268450493)
+++++++++++++run select than press f5
select * from student where roll_no=1
+++++++++++++++++++++++++++run select than press f5
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
how would you improve etl (extract, transform, load) throughput?
How to use subqueries with the in operators in ms sql server?
What gets stored inside msdb database?
Can you pass expressions to stored procedure parameters?
what are the types of indexes? : Sql server database administration
What is relationship? What number of sorts of relationship are there?
What are rows and columns?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is nonclustered index with included columns ?
Explain identity in sql server?
What is the process of indexing?
What are the advantages of paper records?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is the difference between a function and a trigger?
Define inner join in sql server joins?
