Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQl query

Status
Not open for further replies.
saina

saina

Programmer
Joined
Jan 19, 2006
Messages
8
Location
US
I have a query which fetches necessary data for all the employees. But now i have to get data for specific people whose employee ids and names are provided.
My question is can i hardcode like
select........
from.......
where empid="12","23"..


 
Sort by date Sort by votes
... where empid in (12,23,...) ...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question Question
How do I use a keyword in a query??
Replies
6
Views
1K
EdLentz
EdLentz
dylim
  • Locked
  • Question Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
1K
dylim
dylim
trandrus
  • Locked
  • Question Question
incrementing a column without having to query the db first
Replies
4
Views
512
Chris Miller
Chris Miller
martinkaeser
  • Locked
  • Question Question
MySQL Query for incrementing field from duplicates in database
Replies
4
Views
596
martinkaeser
martinkaeser
madcelt
  • Locked
  • Question Question
Select query not showing error but not showing result either
Replies
2
Views
483
madcelt
madcelt

Part and Inventory Search

Sponsor

Back
Top